eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PURGE_PKG dependencies on CN_COMMISSION_HEADERS

Line 50: -- Delete transactions from CN_COMMISSION_HEADERS

46: --DELETE FROM CN_PROCESS_AUDITS;
47: --DELETE FROM CN_PROCESS_AUDIT_LINES;
48:
49: IF (x_salesrep_id IS NOT NULL) THEN
50: -- Delete transactions from CN_COMMISSION_HEADERS
51: DELETE FROM CN_COMMISSION_HEADERS
52: WHERE direct_salesrep_id = x_salesrep_id
53: AND processed_date between l_start_date and l_end_date;
54: COMMIT;

Line 51: DELETE FROM CN_COMMISSION_HEADERS

47: --DELETE FROM CN_PROCESS_AUDIT_LINES;
48:
49: IF (x_salesrep_id IS NOT NULL) THEN
50: -- Delete transactions from CN_COMMISSION_HEADERS
51: DELETE FROM CN_COMMISSION_HEADERS
52: WHERE direct_salesrep_id = x_salesrep_id
53: AND processed_date between l_start_date and l_end_date;
54: COMMIT;
55:

Line 285: -- Delete transactions from CN_COMMISSION_HEADERS

281: WHERE salesrep_id = x_salesrep_id
282: AND processed_period_id between l_start_period_id and l_end_period_id;
283: COMMIT;
284: ELSE
285: -- Delete transactions from CN_COMMISSION_HEADERS
286: DELETE FROM CN_COMMISSION_HEADERS
287: WHERE direct_salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
288: AND processed_date between l_start_date and l_end_date;
289: COMMIT;

Line 286: DELETE FROM CN_COMMISSION_HEADERS

282: AND processed_period_id between l_start_period_id and l_end_period_id;
283: COMMIT;
284: ELSE
285: -- Delete transactions from CN_COMMISSION_HEADERS
286: DELETE FROM CN_COMMISSION_HEADERS
287: WHERE direct_salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
288: AND processed_date between l_start_date and l_end_date;
289: COMMIT;
290: