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_ROLE_PAY_GROUPS_PVT dependencies on JTF_RS_SALESREPS

Line 816: FROM jtf_rs_Salesreps s,

812: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id; */
813:
814: --raj reddy for bug fix 8845580
815: SELECT sr.role_id, sr.srp_role_id,sr.start_date, nvl(sr.end_date,l_null_date) end_date,sr.org_id
816: FROM jtf_rs_Salesreps s,
817: cn_srp_roles sr
818: WHERE sr.salesrep_id = s.salesrep_id
819: AND sr.salesrep_id = p_salesrep_id
820: AND sr.org_id = p_org_id

Line 849: FROM jtf_rs_Salesreps s,

845: */
846: --raj reddy for bug fix 8845580
847: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
848: SELECT sr.srp_role_id,sr.salesrep_id,sr.start_date,sr.end_date,sr.org_id
849: FROM jtf_rs_Salesreps s,
850: cn_srp_roles sr
851: WHERE sr.salesrep_id = s.salesrep_id
852: AND sr.role_id = l_role_id
853: AND sr.org_id = l_org_id