APPS.CN_COMP_PLAN_PVT dependencies on CN_ROLES

Line 1321: cn_roles r

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;
1325: l_counter NUMBER;

Line 1747: cn_roles r,

1743: spa.start_date,
1744: spa.end_date
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