APPS.CN_COMP_PLANS_PKG dependencies on CN_QUOTA_ASSIGNS

Line 119: cn_quota_assigns qa

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

Line 288: FROM cn_quota_assigns qa,

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

Line 301: FROM cn_quota_assigns qa

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

Line 333: FROM cn_quota_assigns qa

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

Line 372: FROM cn_quota_assigns qa,

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

Line 707: cn_quota_assigns_pkg.begin_record

703:
704: IF SQL%FOUND THEN
705: -- Delete all quota assignments that belong to the plan
706: -- this wil cascade to all child tables
707: cn_quota_assigns_pkg.begin_record
708: (X_Operation => 'DELETE',
709: X_Quota_Id => null, -- delete all quotas assigned to plan
710: X_Comp_Plan_Id => x_comp_plan_id,
711: X_Quota_Assign_Id => l_junk, -- not used

Line 928: FROM cn_quota_assigns qa,

924: CURSOR quotas IS
925: SELECT qa.quota_id
926: ,q.quota_type_code
927: ,q.name
928: FROM cn_quota_assigns qa,
929: cn_quotas_v q
930: WHERE qa.comp_plan_id = x_comp_plan_id
931: AND qa.quota_id = q.quota_id;
932: quota_rec quotas%ROWTYPE;