APPS.ICX_POR_BULK_LDR_PURGE dependencies on ICX_POR_BATCH_JOBS
Line 26: DELETE FROM icx_por_batch_jobs
22: INTO gcommit_size
23: FROM dual;
24:
25: WHILE l_continue LOOP 26: DELETE FROM icx_por_batch_jobs 27: WHERE submission_datetime <= (SYSDATE-p_no_of_days)
28: AND ROWNUM <= gcommit_size
29: RETURNING job_number BULK COLLECT INTO gDeleteJobNumbers;
30: