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_PAYGROUP_PVT dependencies on CN_SRP_ROLES

Line 686: FROM cn_srp_roles

682: -- Get the Role info for Each Salesreps
683: -- Added KS
684: CURSOR get_roles (p_salesrep_id NUMBER,p_org_id NUMBER) IS
685: SELECT role_id
686: FROM cn_srp_roles
687: WHERE salesrep_id = p_salesrep_id
688: and org_id = p_org_id;
689:
690: --

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