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_RS_REP_MGR_DENORM_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 51: jtf_rs_resource_extns rsc

47: rlt.role_relate_id
48: FROM jtf_rs_role_relations rlt,
49: jtf_rs_group_members mem,
50: jtf_rs_roles_B rol,
51: jtf_rs_resource_extns rsc
52: WHERE rlt.role_relate_id = l_role_relate_id
53: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
54: AND rlt.role_resource_id = mem.group_member_id
55: AND rlt.role_id = rol.role_id

Line 85: jtf_rs_resource_extns rsc

81: rlt.role_relate_id
82: FROM jtf_rs_role_relations rlt,
83: jtf_rs_group_members mem,
84: jtf_rs_roles_B rol,
85: jtf_rs_resource_extns rsc
86: WHERE mem.group_id = l_group_id
87: AND mem.group_member_id = rlt.role_resource_id
88: AND nvl(rlt.delete_flag,'N') <> 'Y'
89: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 315: jtf_rs_resource_extns rsc

311: rlt.role_relate_id
312: FROM jtf_rs_role_relations rlt,
313: jtf_rs_group_members mem,
314: jtf_rs_roles_b rol,
315: jtf_rs_resource_extns rsc
316: WHERE mem.group_id = l_group_id
317: AND mem.group_member_id = rlt.role_resource_id
318: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
319: AND rlt.role_id = rol.role_id

Line 1181: jtf_rs_resource_extns rsc

1177: rlt.role_relate_id
1178: FROM jtf_rs_role_relations rlt,
1179: jtf_rs_group_members mem,
1180: jtf_rs_roles_B rol,
1181: jtf_rs_resource_extns rsc
1182: WHERE rlt.role_relate_id = l_role_relate_id
1183: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
1184: AND rlt.role_resource_id = mem.group_member_id
1185: AND rlt.role_id = rol.role_id

Line 1215: jtf_rs_resource_extns rsc

1211: rlt.role_relate_id
1212: FROM jtf_rs_role_relations rlt,
1213: jtf_rs_group_members mem,
1214: jtf_rs_roles_B rol,
1215: jtf_rs_resource_extns rsc
1216: WHERE mem.group_id = l_group_id
1217: AND mem.group_member_id = rlt.role_resource_id
1218: AND nvl(rlt.delete_flag,'N') <> 'Y'
1219: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 1423: jtf_rs_resource_extns rsc

1419: rlt.role_relate_id
1420: FROM jtf_rs_role_relations rlt,
1421: jtf_rs_group_members mem,
1422: jtf_rs_roles_b rol,
1423: jtf_rs_resource_extns rsc
1424: WHERE mem.group_id = l_group_id
1425: AND mem.group_member_id = rlt.role_resource_id
1426: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
1427: AND rlt.role_id = rol.role_id

Line 3037: jtf_rs_resource_extns rsc

3033: rlt.role_relate_id
3034: FROM jtf_rs_role_relations rlt,
3035: jtf_rs_group_members mem,
3036: jtf_rs_roles_B rol,
3037: jtf_rs_resource_extns rsc
3038: WHERE rlt.role_relate_id = l_role_relate_id
3039: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
3040: AND rlt.role_resource_id = mem.group_member_id
3041: AND rlt.role_id = rol.role_id

Line 3543: jtf_rs_resource_extns rsc

3539: rlt.role_relate_id
3540: FROM jtf_rs_role_relations rlt,
3541: jtf_rs_group_members mem,
3542: jtf_rs_roles_B rol,
3543: jtf_rs_resource_extns rsc
3544: WHERE mem.group_id = p_group_id
3545: AND nvl(mem.delete_flag,'N') <> 'Y'
3546: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
3547: AND rlt.role_resource_id = mem.group_member_id

Line 3571: jtf_rs_resource_extns rsc

3567: rlt.role_relate_id
3568: FROM jtf_rs_role_relations rlt,
3569: jtf_rs_group_members mem,
3570: jtf_rs_roles_B rol,
3571: jtf_rs_resource_extns rsc
3572: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
3573: AND rlt.role_resource_id = mem.group_member_id
3574: AND rlt.role_id = rol.role_id
3575: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 4049: ( p_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,

4045:
4046: par_mgr_rec par_mgr_cur%rowtype;
4047:
4048: TYPE MGR_TYPE IS RECORD
4049: ( p_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
4050: p_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
4051: p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4052: p_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4053: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

Line 4050: p_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,

4046: par_mgr_rec par_mgr_cur%rowtype;
4047:
4048: TYPE MGR_TYPE IS RECORD
4049: ( p_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
4050: p_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
4051: p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4052: p_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4053: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
4054: p_start_date_active DATE,

Line 4097: jtf_rs_resource_extns rsc

4093: rsc.category
4094: FROM jtf_rs_group_members mem,
4095: jtf_rs_role_relations rlt,
4096: jtf_rs_roles_B rol,
4097: jtf_rs_resource_extns rsc
4098: WHERE mem.group_id = l_group_id
4099: AND mem.group_member_id = rlt.role_resource_id
4100: AND nvl(rlt.delete_flag,'N') <> 'Y'
4101: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 4128: jtf_rs_resource_extns rsc

4124: rsc.category
4125: FROM jtf_rs_group_members mem,
4126: jtf_rs_role_relations rlt,
4127: jtf_rs_roles_B rol,
4128: jtf_rs_resource_extns rsc
4129: WHERE mem.group_id = l_group_id
4130: AND mem.group_member_id = rlt.role_resource_id
4131: AND nvl(rlt.delete_flag,'N') <> 'Y'
4132: AND nvl(mem.delete_flag,'N') <> 'Y'