APPS.CN_COMP_PLANS_PKG dependencies on CN_QUOTA_ASSIGNS

Line 120: cn_quota_assigns qa

116:
117: cursor get_pe_info is
118: select q.quota_id, q.start_date, q.end_date
119: from cn_quotas_v q,
120: cn_quota_assigns qa
121: where qa.comp_plan_id = x_comp_plan_id
122: and q.quota_id = qa.quota_id
123: and q.quota_type_code IN ('EXTERNAL', 'FORMULA');
124:

Line 289: FROM cn_quota_assigns qa,

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
292: WHERE qa.quota_id = q.quota_id
293: AND q.quota_id = rqa.quota_id

Line 302: FROM cn_quota_assigns qa

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;
305:
306: schedule_rec schedules%ROWTYPE;

Line 334: FROM cn_quota_assigns qa

330: -- called after quota, quota rule or trx factor update
331: UPDATE cn_comp_plans
332: SET status_code = x_status_code
333: WHERE comp_plan_id IN (SELECT qa.comp_plan_id
334: FROM cn_quota_assigns qa
335: WHERE qa.quota_id = x_quota_id)
336: ;
337:
338: IF x_status_code = 'INCOMPLETE' THEN

Line 373: FROM cn_quota_assigns qa,

369: -- Called after rate table update
370: UPDATE cn_comp_plans
371: SET status_code = x_status_code
372: WHERE comp_plan_id IN (SELECT qa.comp_plan_id
373: FROM cn_quota_assigns qa,
374: cn_quotas_v q,
375: cn_rt_quota_asgns rqa
376: WHERE qa.quota_id = q.quota_id
377: AND q.quota_id = rqa.quota_id

Line 725: cn_quota_assigns_pkg.begin_record

721:
722: IF SQL%FOUND THEN
723: -- Delete all quota assignments that belong to the plan
724: -- this wil cascade to all child tables
725: cn_quota_assigns_pkg.begin_record
726: (X_Operation => 'DELETE',
727: X_Quota_Id => null, -- delete all quotas assigned to plan
728: X_Comp_Plan_Id => x_comp_plan_id,
729: X_Quota_Assign_Id => l_junk, -- not used

Line 954: FROM cn_quota_assigns qa,

950: CURSOR quotas IS
951: SELECT qa.quota_id
952: ,q.quota_type_code
953: ,q.name
954: FROM cn_quota_assigns qa,
955: cn_quotas_v q
956: WHERE qa.comp_plan_id = x_comp_plan_id
957: AND qa.quota_id = q.quota_id;
958: quota_rec quotas%ROWTYPE;