APPS.CN_PURGE_PKG dependencies on CN_PAYRUNS

Line 233: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS

229:
230: -- Delete Payment from CN_PAYMENT_WORKSHEETS, CN_PAYMENT_API
231: DELETE FROM CN_PAYMENT_WORKSHEETS
232: WHERE salesrep_id = x_salesrep_id
233: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS
234: WHERE accounting_period_id between l_start_period_id and l_end_period_id);
235: COMMIT;
236:
237: DELETE FROM CN_PAYMENT_API

Line 240: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS

236:
237: DELETE FROM CN_PAYMENT_API
238: WHERE salesrep_id = x_salesrep_id
239: AND period_id between l_start_period_id and l_end_period_id
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

Line 467: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS

463:
464: -- Delete Payment from CN_PAYMENT_WORKSHEETS, CN_PAYMENT_API
465: DELETE FROM CN_PAYMENT_WORKSHEETS
466: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
467: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS
468: WHERE accounting_period_id between l_start_period_id and l_end_period_id);
469: COMMIT;
470:
471: DELETE FROM CN_PAYMENT_API

Line 474: AND payrun_id IN (SELECT payrun_id FROM CN_PAYRUNS

470:
471: DELETE FROM CN_PAYMENT_API
472: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
473: AND period_id between l_start_period_id and l_end_period_id
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