APPS.CN_PURGE_PKG dependencies on CN_LEDGER_JOURNAL_ENTRIES

Line 244: -- Delete journal entries from CN_LEDGER_JOURNAL_ENTRIES

240: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS
241: WHERE accounting_period_id between l_start_period_id and l_end_period_id);
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);

Line 245: DELETE FROM CN_LEDGER_JOURNAL_ENTRIES

241: WHERE accounting_period_id between l_start_period_id and l_end_period_id);
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;

Line 478: -- Delete journal entries from CN_LEDGER_JOURNAL_ENTRIES

474: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS
475: WHERE accounting_period_id between l_start_period_id and l_end_period_id);
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);

Line 479: DELETE FROM CN_LEDGER_JOURNAL_ENTRIES

475: WHERE accounting_period_id between l_start_period_id and l_end_period_id);
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;