APPS.CN_PURGE_PKG dependencies on CN_SRP_PERIOD_QUOTAS

Line 200: -- Update CN_SRP_PERIOD_QUOTAS

196: WHERE salesrep_id = x_salesrep_id
197: AND period_id between l_start_period_id and l_end_period_id;
198: COMMIT;
199:
200: -- Update CN_SRP_PERIOD_QUOTAS
201: UPDATE cn_srp_period_quotas SET
202: commission_payed_itd = (commission_payed_itd - nvl(commission_payed_ptd,0)),
203: commission_payed_ptd = 0,
204: perf_achieved_itd = (perf_achieved_itd - nvl(perf_achieved_ptd,0)),

Line 201: UPDATE cn_srp_period_quotas SET

197: AND period_id between l_start_period_id and l_end_period_id;
198: COMMIT;
199:
200: -- Update CN_SRP_PERIOD_QUOTAS
201: UPDATE cn_srp_period_quotas SET
202: commission_payed_itd = (commission_payed_itd - nvl(commission_payed_ptd,0)),
203: commission_payed_ptd = 0,
204: perf_achieved_itd = (perf_achieved_itd - nvl(perf_achieved_ptd,0)),
205: perf_achieved_ptd = 0,

Line 434: -- Update CN_SRP_PERIOD_QUOTAS

430: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
431: AND period_id between l_start_period_id and l_end_period_id;
432: COMMIT;
433:
434: -- Update CN_SRP_PERIOD_QUOTAS
435: UPDATE cn_srp_period_quotas SET
436: commission_payed_itd = (commission_payed_itd - nvl(commission_payed_ptd,0)),
437: commission_payed_ptd = 0,
438: perf_achieved_itd = (perf_achieved_itd - nvl(perf_achieved_ptd,0)),

Line 435: UPDATE cn_srp_period_quotas SET

431: AND period_id between l_start_period_id and l_end_period_id;
432: COMMIT;
433:
434: -- Update CN_SRP_PERIOD_QUOTAS
435: UPDATE cn_srp_period_quotas SET
436: commission_payed_itd = (commission_payed_itd - nvl(commission_payed_ptd,0)),
437: commission_payed_ptd = 0,
438: perf_achieved_itd = (perf_achieved_itd - nvl(perf_achieved_ptd,0)),
439: perf_achieved_ptd = 0,