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 52: jtf_rs_resource_extns rsc

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

Line 86: jtf_rs_resource_extns rsc

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

Line 316: jtf_rs_resource_extns rsc

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

Line 1182: jtf_rs_resource_extns rsc

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

Line 1216: jtf_rs_resource_extns rsc

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

Line 1424: jtf_rs_resource_extns rsc

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

Line 3050: jtf_rs_resource_extns rsc

3046: rlt.role_relate_id
3047: FROM jtf_rs_role_relations rlt,
3048: jtf_rs_group_members mem,
3049: jtf_rs_roles_B rol,
3050: jtf_rs_resource_extns rsc
3051: WHERE rlt.role_relate_id = l_role_relate_id
3052: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
3053: AND rlt.role_resource_id = mem.group_member_id
3054: AND rlt.role_id = rol.role_id

Line 3556: jtf_rs_resource_extns rsc

3552: rlt.role_relate_id
3553: FROM jtf_rs_role_relations rlt,
3554: jtf_rs_group_members mem,
3555: jtf_rs_roles_B rol,
3556: jtf_rs_resource_extns rsc
3557: WHERE mem.group_id = p_group_id
3558: AND nvl(mem.delete_flag,'N') <> 'Y'
3559: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
3560: AND rlt.role_resource_id = mem.group_member_id

Line 3584: jtf_rs_resource_extns rsc

3580: rlt.role_relate_id
3581: FROM jtf_rs_role_relations rlt,
3582: jtf_rs_group_members mem,
3583: jtf_rs_roles_B rol,
3584: jtf_rs_resource_extns rsc
3585: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
3586: AND rlt.role_resource_id = mem.group_member_id
3587: AND rlt.role_id = rol.role_id
3588: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 4062: ( p_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,

4058:
4059: par_mgr_rec par_mgr_cur%rowtype;
4060:
4061: TYPE MGR_TYPE IS RECORD
4062: ( p_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
4063: p_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
4064: p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4065: p_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4066: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

Line 4063: p_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,

4059: par_mgr_rec par_mgr_cur%rowtype;
4060:
4061: TYPE MGR_TYPE IS RECORD
4062: ( p_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
4063: p_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE,
4064: p_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
4065: p_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
4066: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
4067: p_start_date_active DATE,

Line 4110: jtf_rs_resource_extns rsc

4106: rsc.category
4107: FROM jtf_rs_group_members mem,
4108: jtf_rs_role_relations rlt,
4109: jtf_rs_roles_B rol,
4110: jtf_rs_resource_extns rsc
4111: WHERE mem.group_id = l_group_id
4112: AND mem.group_member_id = rlt.role_resource_id
4113: AND nvl(rlt.delete_flag,'N') <> 'Y'
4114: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 4141: jtf_rs_resource_extns rsc

4137: rsc.category
4138: FROM jtf_rs_group_members mem,
4139: jtf_rs_role_relations rlt,
4140: jtf_rs_roles_B rol,
4141: jtf_rs_resource_extns rsc
4142: WHERE mem.group_id = l_group_id
4143: AND mem.group_member_id = rlt.role_resource_id
4144: AND nvl(rlt.delete_flag,'N') <> 'Y'
4145: AND nvl(mem.delete_flag,'N') <> 'Y'