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.AHL_APPROVALS_PVT dependencies on JTF_RS_ROLE_RELATIONS_VL

Line 3251: FROM jtf_rs_role_relations_vl JRRV

3247:
3248: CURSOR c_approver_id_role (approver_name IN VARCHAR2)
3249: IS
3250: SELECT DISTINCT JRRV.role_id
3251: FROM jtf_rs_role_relations_vl JRRV
3252: WHERE JRRV.role_type_code in ('AHLAPPR', 'AHLGAPPR')
3253: AND UPPER(JRRV.role_name) LIKE UPPER(approver_name);
3254:
3255: -- Bug 4919031 (Perf Fix)

Line 3283: FROM jtf_rs_role_relations_vl JRRV

3279: CURSOR c_approver_name_id_role (approver_name IN VARCHAR2,
3280: approver_id IN NUMBER)
3281: IS
3282: SELECT DISTINCT JRRV.role_id
3283: FROM jtf_rs_role_relations_vl JRRV
3284: WHERE JRRV.role_type_code in ('AHLAPPR', 'AHLGAPPR')
3285: AND UPPER(JRRV.role_name) LIKE UPPER(approver_name)
3286: AND JRRV.role_id = approver_id;
3287: