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 190: FROM cn_srp_plan_assigns

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

Line 286: FROM cn_srp_plan_assigns pa

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

Line 299: FROM cn_srp_plan_assigns pa

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