APPS.CN_PAYGROUP_PVT dependencies on CN_ROLE_PLANS

Line 710: cn_srp_roles sr, cn_role_plans rp

706:
707: CURSOR get_affected_reps IS
708: select sr.srp_role_id, rp.role_plan_id
709: from cn_srp_pay_groups spg, cn_pay_groups pg,
710: cn_srp_roles sr, cn_role_plans rp
711: where spg.end_date is null
712: and spg.pay_group_id = pg.pay_group_id
713: and pg.pay_group_id = p_paygroup_rec.pay_group_id
714: and sr.salesrep_id = spg.salesrep_id