APPS.CN_PURGE_PKG dependencies on CN_PAYMENT_WORKSHEETS

Line 230: -- Delete Payment from CN_PAYMENT_WORKSHEETS, CN_PAYMENT_API

226: WHERE salesrep_id = x_salesrep_id
227: AND period_id between l_start_period_id and l_end_period_id;
228: COMMIT;
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);

Line 231: DELETE FROM CN_PAYMENT_WORKSHEETS

227: AND period_id between l_start_period_id and l_end_period_id;
228: COMMIT;
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;

Line 464: -- Delete Payment from CN_PAYMENT_WORKSHEETS, CN_PAYMENT_API

460: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
461: AND period_id between l_start_period_id and l_end_period_id;
462: COMMIT;
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);

Line 465: DELETE FROM CN_PAYMENT_WORKSHEETS

461: AND period_id between l_start_period_id and l_end_period_id;
462: COMMIT;
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;