APPS.CN_PURGE_PKG dependencies on CN_COMM_LINES_API

Line 251: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES

247: WHERE salesrep_id = x_salesrep_id
248: AND period_id between l_start_period_id and l_end_period_id);
249: COMMIT;
250:
251: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES
252: DELETE FROM CN_COMM_LINES_API
253: WHERE (employee_number, type) = (SELECT employee_number, type FROM cn_salesreps WHERE salesrep_id = x_salesrep_id)
254: AND processed_date between l_start_date and l_end_date;
255: COMMIT;

Line 252: DELETE FROM CN_COMM_LINES_API

248: AND period_id between l_start_period_id and l_end_period_id);
249: COMMIT;
250:
251: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES
252: DELETE FROM CN_COMM_LINES_API
253: WHERE (employee_number, type) = (SELECT employee_number, type FROM cn_salesreps WHERE salesrep_id = x_salesrep_id)
254: AND processed_date between l_start_date and l_end_date;
255: COMMIT;
256:

Line 485: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES

481: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
482: AND period_id between l_start_period_id and l_end_period_id);
483: COMMIT;
484:
485: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES
486: DELETE FROM CN_COMM_LINES_API
487: WHERE (employee_number, TYPE) IN (SELECT employee_number, TYPE FROM cn_salesreps)
488: AND processed_date between l_start_date and l_end_date;
489: COMMIT;

Line 486: DELETE FROM CN_COMM_LINES_API

482: AND period_id between l_start_period_id and l_end_period_id);
483: COMMIT;
484:
485: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES
486: DELETE FROM CN_COMM_LINES_API
487: WHERE (employee_number, TYPE) IN (SELECT employee_number, TYPE FROM cn_salesreps)
488: AND processed_date between l_start_date and l_end_date;
489: COMMIT;
490: