APPS.CN_PURGE_PKG dependencies on CN_COMMISSION_LINES

Line 56: -- Delete transactions from CN_COMMISSION_LINES

52: WHERE direct_salesrep_id = x_salesrep_id
53: AND processed_date between l_start_date and l_end_date;
54: COMMIT;
55:
56: -- Delete transactions from CN_COMMISSION_LINES
57: DELETE FROM CN_COMMISSION_LINES
58: WHERE credited_salesrep_id = x_salesrep_id
59: AND processed_period_id between l_start_period_id and l_end_period_id;
60: COMMIT;

Line 57: DELETE FROM CN_COMMISSION_LINES

53: AND processed_date between l_start_date and l_end_date;
54: COMMIT;
55:
56: -- Delete transactions from CN_COMMISSION_LINES
57: DELETE FROM CN_COMMISSION_LINES
58: WHERE credited_salesrep_id = x_salesrep_id
59: AND processed_period_id between l_start_period_id and l_end_period_id;
60: COMMIT;
61:

Line 291: -- Delete transactions from CN_COMMISSION_LINES

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:
291: -- Delete transactions from CN_COMMISSION_LINES
292: DELETE FROM CN_COMMISSION_LINES
293: WHERE processed_period_id between l_start_period_id and l_end_period_id;
294: COMMIT;
295:

Line 292: DELETE FROM CN_COMMISSION_LINES

288: AND processed_date between l_start_date and l_end_date;
289: COMMIT;
290:
291: -- Delete transactions from CN_COMMISSION_LINES
292: DELETE FROM CN_COMMISSION_LINES
293: WHERE processed_period_id between l_start_period_id and l_end_period_id;
294: COMMIT;
295:
296: -- Update CN_SRP_PERIODS