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_GROUP_MEMBERS

Line 49: jtf_rs_group_members mem,

45: rol.manager_flag,
46: rsc.category,
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'

Line 83: jtf_rs_group_members mem,

79: rol.manager_flag,
80: rsc.category,
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

Line 113: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

109:
110: other_rec other_cur%rowtype;
111:
112: --cursor for duplicate check
113: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
114: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
115: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
116: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
117: l_start_date_active DATE,

Line 114: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

110: other_rec other_cur%rowtype;
111:
112: --cursor for duplicate check
113: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
114: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
115: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
116: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
117: l_start_date_active DATE,
118: l_end_date_active DATE)

Line 116: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

112: --cursor for duplicate check
113: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
114: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
115: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
116: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
117: l_start_date_active DATE,
118: l_end_date_active DATE)
119: IS
120: SELECT person_id

Line 168: FROM jtf_rs_group_members mem,

164: rlt.end_date_active,
165: rol.admin_flag ,
166: rol.manager_flag,
167: rlt.role_relate_id
168: FROM jtf_rs_group_members mem,
169: jtf_rs_role_relations rlt,
170: jtf_rs_roles_B rol
171: WHERE mem.group_id = l_group_id
172: AND mem.group_member_id = rlt.role_resource_id

Line 225: FROM jtf_rs_group_members mem,

221: mem.person_id,
222: rlt.start_date_active,
223: rlt.end_date_active,
224: rlt.role_relate_id
225: FROM jtf_rs_group_members mem,
226: jtf_rs_role_relations rlt,
227: jtf_rs_roles_b rol
228: WHERE mem.group_id = l_group_id
229: AND mem.group_member_id = rlt.role_resource_id

Line 255: FROM jtf_rs_group_members mem,

251: mem.person_id,
252: rlt.start_date_active,
253: rlt.end_date_active,
254: rlt.role_relate_id
255: FROM jtf_rs_group_members mem,
256: jtf_rs_role_relations rlt,
257: jtf_rs_roles_b rol
258: WHERE mem.group_id = l_group_id
259: AND mem.group_member_id = rlt.role_resource_id

Line 313: jtf_rs_group_members mem,

309: rol.member_flag,
310: rsc.category,
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

Line 1179: jtf_rs_group_members mem,

1175: rol.manager_flag,
1176: rsc.category,
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'

Line 1213: jtf_rs_group_members mem,

1209: rol.manager_flag,
1210: rsc.category,
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

Line 1236: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

1232:
1233: other_rec other_cur%rowtype;
1234:
1235: --cursor for duplicate check
1236: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
1237: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
1238: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1239: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
1240: l_start_date_active DATE,

Line 1237: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

1233: other_rec other_cur%rowtype;
1234:
1235: --cursor for duplicate check
1236: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
1237: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
1238: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1239: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
1240: l_start_date_active DATE,
1241: l_end_date_active DATE)

Line 1239: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

1235: --cursor for duplicate check
1236: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
1237: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
1238: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
1239: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
1240: l_start_date_active DATE,
1241: l_end_date_active DATE)
1242: IS
1243: SELECT person_id

Line 1282: FROM jtf_rs_group_members mem,

1278: rlt.end_date_active,
1279: rol.admin_flag ,
1280: rol.manager_flag,
1281: rlt.role_relate_id
1282: FROM jtf_rs_group_members mem,
1283: jtf_rs_role_relations rlt,
1284: jtf_rs_roles_B rol
1285: WHERE mem.group_id = l_group_id
1286: AND mem.group_member_id = rlt.role_resource_id

Line 1336: FROM jtf_rs_group_members mem,

1332: mem.person_id,
1333: rlt.start_date_active,
1334: rlt.end_date_active,
1335: rlt.role_relate_id
1336: FROM jtf_rs_group_members mem,
1337: jtf_rs_role_relations rlt,
1338: jtf_rs_roles_b rol
1339: WHERE mem.group_id = l_group_id
1340: AND mem.group_member_id = rlt.role_resource_id

Line 1366: FROM jtf_rs_group_members mem,

1362: mem.person_id,
1363: rlt.start_date_active,
1364: rlt.end_date_active,
1365: rlt.role_relate_id
1366: FROM jtf_rs_group_members mem,
1367: jtf_rs_role_relations rlt,
1368: jtf_rs_roles_b rol
1369: WHERE mem.group_id = l_group_id
1370: AND mem.group_member_id = rlt.role_resource_id

Line 1421: jtf_rs_group_members mem,

1417: rol.member_flag,
1418: rsc.category,
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

Line 2832: jtf_rs_group_members mem

2828: CURSOR par_role_relate_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
2829: IS
2830: SELECT role_relate_id
2831: FROM JTF_RS_ROLE_RELATIONS rlt,
2832: jtf_rs_group_members mem
2833: WHERE mem.group_id = l_group_id
2834: AND mem.group_member_id = rlt.role_resource_id
2835: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
2836: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 2845: jtf_rs_group_members mem

2841: CURSOR child_role_relate_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
2842: IS
2843: SELECT role_relate_id
2844: FROM JTF_RS_ROLE_RELATIONS rlt,
2845: jtf_rs_group_members mem
2846: WHERE mem.group_id = l_group_id
2847: AND mem.group_member_id = rlt.role_resource_id
2848: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
2849: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 3035: jtf_rs_group_members mem,

3031: rol.manager_flag,
3032: rsc.category,
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'

Line 3051: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

3047: mem_dtls_rec mem_dtls_cur%rowtype;
3048:
3049:
3050: --cursor for duplicate check
3051: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3052: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3053: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3054: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
3055: l_start_date_active DATE,

Line 3052: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

3048:
3049:
3050: --cursor for duplicate check
3051: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3052: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3053: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3054: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
3055: l_start_date_active DATE,
3056: l_end_date_active DATE)

Line 3054: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

3050: --cursor for duplicate check
3051: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3052: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3053: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3054: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
3055: l_start_date_active DATE,
3056: l_end_date_active DATE)
3057: IS
3058: SELECT person_id

Line 3114: FROM jtf_rs_group_members mem,

3110: mem.person_id,
3111: rlt.start_date_active,
3112: rlt.end_date_active,
3113: rlt.role_relate_id
3114: FROM jtf_rs_group_members mem,
3115: jtf_rs_role_relations rlt,
3116: jtf_rs_roles_b rol
3117: WHERE mem.group_id = l_group_id
3118: AND mem.group_member_id = rlt.role_resource_id

Line 3144: FROM jtf_rs_group_members mem,

3140: mem.person_id,
3141: rlt.start_date_active,
3142: rlt.end_date_active,
3143: rlt.role_relate_id
3144: FROM jtf_rs_group_members mem,
3145: jtf_rs_role_relations rlt,
3146: jtf_rs_roles_b rol
3147: WHERE mem.group_id = l_group_id
3148: AND mem.group_member_id = rlt.role_resource_id

Line 3541: jtf_rs_group_members mem,

3537: nvl(rol.member_flag,'N'),'REP','OTHER') ROLE_TYPE,
3538: rsc.category,
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'

Line 3569: jtf_rs_group_members mem,

3565: nvl(rol.member_flag,'N'),'REP','OTHER') ROLE_TYPE,
3566: rsc.category,
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

Line 3871: jtf_rs_group_members mem

3867: IS
3868: CURSOR c_child_role_relate_cur(l_group_id IN NUMBER) IS
3869: SELECT rlt.role_relate_id
3870: FROM jtf_rs_role_relations rlt,
3871: jtf_rs_group_members mem
3872: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
3873: AND rlt.role_resource_id = mem.group_member_id
3874: AND nvl(rlt.delete_flag,'N') <> 'Y'
3875: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 3883: jtf_rs_group_members mem

3879:
3880: CURSOR c_parent_role_relate_cur(l_parent_group_id IN NUMBER) IS
3881: SELECT rlt.role_relate_id
3882: FROM jtf_rs_role_relations rlt,
3883: jtf_rs_group_members mem
3884: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
3885: AND rlt.role_resource_id = mem.group_member_id
3886: AND nvl(rlt.delete_flag,'N') <> 'Y'
3887: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 4025: FROM jtf_rs_group_members mem,

4021: rlt.start_date_active,
4022: rlt.end_date_active,
4023: rol.admin_flag ,
4024: rol.manager_flag
4025: FROM jtf_rs_group_members mem,
4026: jtf_rs_role_relations rlt,
4027: jtf_rs_roles_B rol
4028: WHERE mem.group_id IN ( select distinct(parent_group_id)
4029: from jtf_rs_groups_denorm

Line 4094: FROM jtf_rs_group_members mem,

4090: rol.admin_flag ,
4091: rol.lead_flag ,
4092: rol.manager_flag,
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

Line 4125: FROM jtf_rs_group_members mem,

4121: rol.admin_flag ,
4122: rol.lead_flag ,
4123: rol.manager_flag,
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