help in csv format

hi all, i do have this form that has an output in csv format
now in the output in some rows some data are repeating having same column data but to differ only to the last column.
how can i delete this?

here's the sql of my form:

declare
   CURSOR C1 IS  
   SELECT COUNT(*) TOT_COUNT
   from receipts r,payments p
   where r.code=p.rct_code
   and r.pcode=p.pcode
   and r.pcode='G3SMIS01'
   and r.bank_provider='CTB'
   and r.date_issued=:cgtemp.cdate;
  

   CURSOR C IS
   select r.cust_name, r.code, p.ded_desc4, p.ded_amt1, p.ref_no, r.remarks