APPS.CN_COMP_PLAN_PVT dependencies on CN_ROLES

Line 1333: cn_roles r

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

Line 1765: cn_roles r,

1761: spa.start_date,
1762: spa.end_date
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