APPS.CN_COMP_PLANS_PKG dependencies on CN_QUOTAS_V

Line 118: from cn_quotas_v q,

114: l_end_date date;
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');

Line 289: cn_quotas_v q,

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
293: AND rqa.rate_schedule_id = X_rate_schedule_id)

Line 373: cn_quotas_v q,

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
377: AND rqa.rate_schedule_id = X_rate_schedule_id)

Line 929: cn_quotas_v q

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;
933: