APPS.CN_PURGE_PKG dependencies on CN_PROCESS_BATCHES

Line 40: -- Delete process batches from CN_PROCESS_BATCHES with status_code = 'VOID'

36: INTO l_end_period_id, l_end_date
37: FROM cn_periods
38: WHERE period_name like x_end_period;
39:
40: -- Delete process batches from CN_PROCESS_BATCHES with status_code = 'VOID'
41: DELETE FROM CN_PROCESS_BATCHES WHERE status_code = 'VOID';
42:
43: -- Delete process audit lines from CN_PROCESS_AUDIT_LINES and CN_PROCESS_AUDITS
44: -- Commented out as this process is taking a very long time for deleting as

Line 41: DELETE FROM CN_PROCESS_BATCHES WHERE status_code = 'VOID';

37: FROM cn_periods
38: WHERE period_name like x_end_period;
39:
40: -- Delete process batches from CN_PROCESS_BATCHES with status_code = 'VOID'
41: DELETE FROM CN_PROCESS_BATCHES WHERE status_code = 'VOID';
42:
43: -- Delete process audit lines from CN_PROCESS_AUDIT_LINES and CN_PROCESS_AUDITS
44: -- Commented out as this process is taking a very long time for deleting as
45: -- there can be lot of records in these tables as part of auditing.