DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on CN_RT_QUOTA_ASGNS

Line 291: cn_rt_quota_asgns rqa

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)
295: ORDER BY pa.salesrep_id, pa.start_date;

Line 375: cn_rt_quota_asgns rqa

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)
379: ;