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_COMP_PLAN_PVT dependencies on CN_ROLE_PLANS

Line 584: FROM cn_role_plans

580: END IF;
581:
582: SELECT COUNT (1)
583: INTO l_temp_count
584: FROM cn_role_plans
585: WHERE comp_plan_id = l_comp_plan_id AND (start_date < l_start_date OR (end_date IS NULL AND l_end_date IS NOT NULL) OR (end_date > l_end_date));
586:
587: IF l_temp_count > 0
588: THEN

Line 1332: FROM cn_role_plans p,

1328: p.start_date,
1329: p.end_date,
1330: p.object_version_number,
1331: r.role_id
1332: FROM cn_role_plans p,
1333: cn_roles r
1334: WHERE p.comp_plan_id = p_comp_plan_id AND r.role_id = p.role_id;
1335:
1336: l_sales_role l_sales_role_cr%ROWTYPE;

Line 1767: cn_role_plans rp

1763: FROM cn_srp_plan_assigns spa,
1764: cn_salesreps s,
1765: cn_roles r,
1766: cn_srp_roles sr,
1767: cn_role_plans rp
1768: WHERE spa.comp_plan_id = p_comp_plan_id
1769: AND spa.salesrep_id = s.salesrep_id
1770: AND spa.role_id = r.role_id
1771: AND sr.srp_role_id = spa.srp_role_id