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.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_RS_ROLES_B

Line 1158: FROM jtf_rs_group_members mem, jtf_rs_roles_b rol, jtf_rs_role_relations rlt

1154: */
1155: BEGIN
1156: SELECT 'VALID'
1157: INTO l_select
1158: FROM jtf_rs_group_members mem, jtf_rs_roles_b rol, jtf_rs_role_relations rlt
1159: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
1160: AND rlt.delete_flag = 'N'
1161: AND sysdate >= rlt.start_date_active
1162: AND (rlt.end_date_active is null OR

Line 1774: , jtf_rs_roles_b rol

1770: select grv.resource_id, grv.group_id, grv.role_code
1771: from
1772: jtf_tty_my_resources_v grv
1773: , JTF_RS_GROUPS_DENORM grpd
1774: , jtf_rs_roles_b rol
1775: WHERE grpd.parent_group_id = grv.parent_group_id
1776: and grpd.group_id IN ( select grv1.group_id
1777: from jtf_rs_group_members grv1
1778: where grv1.resource_id = cl_eff_resource_id )