2422: OR refTR2.occurrence_id = TR2.occurrence_id
2423: and refTR2.event_type_code IN('REMIT_COLL_DOC' ,'REMIT_FACT_DOC')
2424: and refTR2.occurrence_status ='CANCELREMIT'
2425: )) jlje ,
2426: gl_code_combinations gcc
2427: WHERE gcc.code_combination_id = jlje.ccid;
2428:
2429:
2430: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;