APPS.CN_COMP_PLAN_PVT dependencies on CN_ROLE_PLANS

Line 576: FROM cn_role_plans

572: END IF;
573:
574: SELECT COUNT (1)
575: INTO l_temp_count
576: FROM cn_role_plans
577: 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));
578:
579: IF l_temp_count > 0
580: THEN

Line 1320: FROM cn_role_plans p,

1316: p.start_date,
1317: p.end_date,
1318: p.object_version_number,
1319: r.role_id
1320: FROM cn_role_plans p,
1321: cn_roles r
1322: WHERE p.comp_plan_id = p_comp_plan_id AND r.role_id = p.role_id;
1323:
1324: l_sales_role l_sales_role_cr%ROWTYPE;

Line 1749: cn_role_plans rp

1745: FROM cn_srp_plan_assigns spa,
1746: cn_salesreps s,
1747: cn_roles r,
1748: cn_srp_roles sr,
1749: cn_role_plans rp
1750: WHERE spa.comp_plan_id = p_comp_plan_id
1751: AND spa.salesrep_id = s.salesrep_id
1752: AND spa.role_id = r.role_id
1753: AND sr.srp_role_id = spa.srp_role_id