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 4360: FROM cn_srp_plan_assigns_all spa, cn_quota_assigns_all qa, cn_quotas_all pe

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

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

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