APPS.CN_PURGE_PKG dependencies on CN_SRP_PER_QUOTA_RC

Line 221: -- CN_SRP_PER_QUOTA_RC

217: AND period_id between l_start_period_id and l_end_period_id;
218:
219: COMMIT;
220:
221: -- CN_SRP_PER_QUOTA_RC
222: UPDATE cn_srp_per_quota_rc SET
223: year_to_date = 0,
224: quarter_to_date = 0,
225: period_to_date = 0

Line 222: UPDATE cn_srp_per_quota_rc SET

218:
219: COMMIT;
220:
221: -- CN_SRP_PER_QUOTA_RC
222: UPDATE cn_srp_per_quota_rc SET
223: year_to_date = 0,
224: quarter_to_date = 0,
225: period_to_date = 0
226: WHERE salesrep_id = x_salesrep_id

Line 455: -- CN_SRP_PER_QUOTA_RC

451: AND period_id between l_start_period_id and l_end_period_id;
452:
453: COMMIT;
454:
455: -- CN_SRP_PER_QUOTA_RC
456: UPDATE cn_srp_per_quota_rc SET
457: year_to_date = 0,
458: quarter_to_date = 0,
459: period_to_date = 0

Line 456: UPDATE cn_srp_per_quota_rc SET

452:
453: COMMIT;
454:
455: -- CN_SRP_PER_QUOTA_RC
456: UPDATE cn_srp_per_quota_rc SET
457: year_to_date = 0,
458: quarter_to_date = 0,
459: period_to_date = 0
460: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)