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_GENERIC_APRV_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1588: FROM JTF_RS_ROLE_RELATIONS rr, JTF_RS_ROLES_B rb

1584: AND approver_sequence = p_current_seq;
1585:
1586: CURSOR c_role_info IS
1587: SELECT rr.ROLE_RESOURCE_ID
1588: FROM JTF_RS_ROLE_RELATIONS rr, JTF_RS_ROLES_B rb
1589: WHERE rr.role_id = rb.role_id
1590: AND rb.role_type_code in( 'AHLGAPPR','AHLAPPR')
1591: AND rr.ROLE_ID = x_object_approver_id
1592: AND rr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'

Line 1598: FROM JTF_RS_ROLE_RELATIONS rr, JTF_RS_ROLES_B rb

1594: and sysdate between nvl(rr.start_date_active,sysdate -1 ) and nvl(rr.end_date_active,sysdate + 1);
1595:
1596: CURSOR c_role_info_count IS
1597: SELECT count(1)
1598: FROM JTF_RS_ROLE_RELATIONS rr, JTF_RS_ROLES_B rb
1599: WHERE rr.role_id = rb.role_id
1600: AND rb.role_type_code in( 'AHLGAPPR','AHLAPPR')
1601: AND rr.ROLE_ID = x_object_approver_id
1602: AND rr.ROLE_RESOURCE_TYPE = 'RS_INDIVIDUAL'

Line 1608: FROM jtf_rs_role_relations rr,

1604: and sysdate between nvl(rr.start_date_active,sysdate -1 ) and nvl(rr.end_date_active,sysdate + 1);
1605:
1606: CURSOR c_default_role_info IS
1607: SELECT rr.role_id
1608: FROM jtf_rs_role_relations rr,
1609: jtf_rs_roles_vl rl
1610: WHERE rr.role_id = rl.role_id
1611: and rl.role_type_code ='AHLAPPR'
1612: AND rl.role_code = 'AHL_DEFAULT_APPROVER'