115: l_end_date date;
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');
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
294: AND rqa.rate_schedule_id = X_rate_schedule_id)
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
378: AND rqa.rate_schedule_id = X_rate_schedule_id)
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;
959: