APPS.CN_COMP_PLANS_PKG dependencies on CN_SRP_PLAN_ASSIGNS

Line 74: FROM cn_srp_plan_assigns

70: X_dummy NUMBER;
71: BEGIN
72: SELECT count(1)
73: INTO x_dummy
74: FROM cn_srp_plan_assigns
75: WHERE comp_plan_id = x_comp_plan_id
76: AND ( start_date < x_start_date
77: OR end_date > x_end_date);
78:

Line 191: FROM cn_srp_plan_assigns

187: X_dummy NUMBER;
188: BEGIN
189: SELECT count(1)
190: INTO x_dummy
191: FROM cn_srp_plan_assigns
192: WHERE comp_plan_id = x_comp_plan_id;
193:
194: if x_dummy > 0 then
195: fnd_message.set_name('CN', 'PLN_PLAN_DELETE_NA');

Line 287: FROM cn_srp_plan_assigns pa

283:
284: CURSOR schedules IS
285: SELECT pa.salesrep_id
286: ,pa.start_date
287: FROM cn_srp_plan_assigns pa
288: WHERE pa.comp_plan_id IN (SELECT qa.comp_plan_id
289: FROM cn_quota_assigns qa,
290: cn_quotas_v q,
291: cn_rt_quota_asgns rqa

Line 300: FROM cn_srp_plan_assigns pa

296:
297: CURSOR quotas IS
298: SELECT pa.salesrep_id
299: ,pa.start_date
300: FROM cn_srp_plan_assigns pa
301: WHERE pa.comp_plan_id IN (SELECT qa.comp_plan_id
302: FROM cn_quota_assigns qa
303: WHERE qa.quota_id = x_quota_id)
304: ORDER BY pa.salesrep_id, pa.start_date;