APPS.CN_PURGE_PKG dependencies on CN_SRP_PERIODS

Line 62: -- Update CN_SRP_PERIODS

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:
62: -- Update CN_SRP_PERIODS
63: UPDATE cn_srp_periods SET
64: balance1_dtd = 0,
65: balance1_ctd = 0,
66: balance1_bbd = 0,

Line 63: UPDATE cn_srp_periods SET

59: AND processed_period_id between l_start_period_id and l_end_period_id;
60: COMMIT;
61:
62: -- Update CN_SRP_PERIODS
63: UPDATE cn_srp_periods SET
64: balance1_dtd = 0,
65: balance1_ctd = 0,
66: balance1_bbd = 0,
67: balance1_bbc = 0,

Line 246: WHERE srp_period_id IN (SELECT srp_period_id FROM CN_SRP_PERIODS

242: COMMIT;
243:
244: -- Delete journal entries from CN_LEDGER_JOURNAL_ENTRIES
245: DELETE FROM CN_LEDGER_JOURNAL_ENTRIES
246: WHERE srp_period_id IN (SELECT srp_period_id FROM CN_SRP_PERIODS
247: WHERE salesrep_id = x_salesrep_id
248: AND period_id between l_start_period_id and l_end_period_id);
249: COMMIT;
250:

Line 296: -- Update CN_SRP_PERIODS

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
297: UPDATE cn_srp_periods SET
298: balance1_dtd = 0,
299: balance1_ctd = 0,
300: balance1_bbd = 0,

Line 297: UPDATE cn_srp_periods SET

293: WHERE processed_period_id between l_start_period_id and l_end_period_id;
294: COMMIT;
295:
296: -- Update CN_SRP_PERIODS
297: UPDATE cn_srp_periods SET
298: balance1_dtd = 0,
299: balance1_ctd = 0,
300: balance1_bbd = 0,
301: balance1_bbc = 0,

Line 480: WHERE srp_period_id IN (SELECT srp_period_id FROM CN_SRP_PERIODS

476: COMMIT;
477:
478: -- Delete journal entries from CN_LEDGER_JOURNAL_ENTRIES
479: DELETE FROM CN_LEDGER_JOURNAL_ENTRIES
480: WHERE srp_period_id IN (SELECT srp_period_id FROM CN_SRP_PERIODS
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: