enhancement in script

Hi, i have this script for the oracle forms :

DECLARE
   CURSOR C1 IS
   SELECT COUNT(*) TOT_COUNT
   from receipts r, checks c
     where r.code=c.rct_code
   and r.pcode=c.pcode
   and r.bank_provider=c.bank_provider
   and r.pcode='G3CIGI01'
   and to_char(r.date_issued,'yyyymmdd')=to_char(:cgtemp.cdate,'yyyymmdd');
CURSOR C IS
   Select r.date_issued,r.doc_type,r.cust_code,r.code,c.bank||' '||c.branch||' '||'#'||c.chk_no "DOC_HEADER",r.pcode,r.rct_amount
   from receipts r, checks c
     where r.code=c.rct_code