APPS.CN_PURGE_PKG dependencies on CN_NOT_TRX

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 257: DELETE FROM cn_not_trx

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:
257: DELETE FROM cn_not_trx
258: WHERE source_trx_id IN (SELECT source_trx_id
259: FROM cn_trx
260: WHERE trx_id IN (SELECT trx_id
261: FROM cn_trx_sales_lines

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 491: DELETE FROM cn_not_trx

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:
491: DELETE FROM cn_not_trx
492: WHERE source_trx_id IN (SELECT source_trx_id
493: FROM cn_trx
494: WHERE trx_id IN (SELECT trx_id
495: FROM cn_trx_sales_lines