output file

hi, have this oracle forms with a script below, now i wanted to have additional line that could sum up the chk amt per drn no.
any tips?


   CURSOR C1 IS
   SELECT COUNT(*) TOT_COUNT
   FROM sbis.bayadcenter b;

   CURSOR C IS
   SELECT b.cisi,b.dep_date,b.branch,b.drn_no,b.chk_no,b.chk_amt
   FROM sbis.bayadcenter b
   where b.dep_date= :cgtemp.dep_date;
  
   CREC  C%ROWTYPE;
   C1REC C1%ROWTYPE;
  
   out_file TEXT_IO.FILE_TYPE;
   txt_file VARCHAR2(30) := :cgtemp.FILENAME;
   temp_text VARCHAR2(5000);
   temp_rowcount NUMBER;
   lv_sqlcode NUMBER;        /* Place to hold SQLCODE */