eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PROC_BATCHES_PKG dependencies on CN_QUOTAS_ALL

Line 4361: FROM cn_srp_plan_assigns_all spa, cn_quota_assigns_all qa, cn_quotas_all pe

4357: AND PLAN.status_code = 'COMPLETE')
4358: OR EXISTS -- comp_plan is active between period start and end date AND a plan element has the salesreps_enddated_flag set to "Y"
4359: (
4360: SELECT 1
4361: FROM cn_srp_plan_assigns_all spa, cn_quota_assigns_all qa, cn_quotas_all pe
4362: WHERE spa.salesrep_id = p_salesrep_id
4363: AND spa.org_id = p_org_id
4364: AND spa.end_date >= p_start_date
4365: AND spa.end_date < p_end_date

Line 4533: FROM cn_srp_plan_assigns_all spa, cn_quota_assigns_all qa, cn_quotas_all pe

4529: ))
4530: OR EXISTS -- comp_plan is active between period start and end date AND a plan element has the salesreps_enddated_flag set to "Y"
4531: (
4532: SELECT 1
4533: FROM cn_srp_plan_assigns_all spa, cn_quota_assigns_all qa, cn_quotas_all pe
4534: WHERE spa.salesrep_id = p_salesrep_id
4535: AND spa.org_id = bat.org_id
4536: AND spa.end_date >= period.start_date
4537: AND spa.end_date < period.end_date