DBA Data[Home] [Help]

APPS.CN_COMP_PLANS_PKG dependencies on CN_RT_QUOTA_ASGNS

Line 290: cn_rt_quota_asgns rqa

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

Line 374: cn_rt_quota_asgns rqa

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