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 50: jtf_rs_group_members mem,

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

Line 84: jtf_rs_group_members mem,

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

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

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

Line 115: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

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

Line 117: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

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

Line 169: FROM jtf_rs_group_members mem,

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

Line 226: FROM jtf_rs_group_members mem,

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

Line 256: FROM jtf_rs_group_members mem,

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

Line 314: jtf_rs_group_members mem,

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

Line 1180: jtf_rs_group_members mem,

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

Line 1214: jtf_rs_group_members mem,

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

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

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

Line 1238: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

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

Line 1240: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

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

Line 1283: FROM jtf_rs_group_members mem,

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

Line 1337: FROM jtf_rs_group_members mem,

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

Line 1367: FROM jtf_rs_group_members mem,

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

Line 1422: jtf_rs_group_members mem,

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

Line 2845: jtf_rs_group_members mem

2841: CURSOR par_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 2858: jtf_rs_group_members mem

2854: CURSOR child_role_relate_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
2855: IS
2856: SELECT role_relate_id
2857: FROM JTF_RS_ROLE_RELATIONS rlt,
2858: jtf_rs_group_members mem
2859: WHERE mem.group_id = l_group_id
2860: AND mem.group_member_id = rlt.role_resource_id
2861: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
2862: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 3048: jtf_rs_group_members mem,

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

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

3060: mem_dtls_rec mem_dtls_cur%rowtype;
3061:
3062:
3063: --cursor for duplicate check
3064: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3065: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3066: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3067: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
3068: l_start_date_active DATE,

Line 3065: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,

3061:
3062:
3063: --cursor for duplicate check
3064: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3065: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3066: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3067: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
3068: l_start_date_active DATE,
3069: l_end_date_active DATE)

Line 3067: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,

3063: --cursor for duplicate check
3064: CURSOR dup_cur(l_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3065: l_manager_person_id JTF_RS_GROUP_MEMBERS.PERSON_ID%TYPE,
3066: l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE,
3067: l_resource_id JTF_RS_GROUP_MEMBERS.RESOURCE_ID%TYPE,
3068: l_start_date_active DATE,
3069: l_end_date_active DATE)
3070: IS
3071: SELECT person_id

Line 3127: FROM jtf_rs_group_members mem,

3123: mem.person_id,
3124: rlt.start_date_active,
3125: rlt.end_date_active,
3126: rlt.role_relate_id
3127: FROM jtf_rs_group_members mem,
3128: jtf_rs_role_relations rlt,
3129: jtf_rs_roles_b rol
3130: WHERE mem.group_id = l_group_id
3131: AND mem.group_member_id = rlt.role_resource_id

Line 3157: FROM jtf_rs_group_members mem,

3153: mem.person_id,
3154: rlt.start_date_active,
3155: rlt.end_date_active,
3156: rlt.role_relate_id
3157: FROM jtf_rs_group_members mem,
3158: jtf_rs_role_relations rlt,
3159: jtf_rs_roles_b rol
3160: WHERE mem.group_id = l_group_id
3161: AND mem.group_member_id = rlt.role_resource_id

Line 3554: jtf_rs_group_members mem,

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

Line 3582: jtf_rs_group_members mem,

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

Line 3884: jtf_rs_group_members mem

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

Line 3896: jtf_rs_group_members mem

3892:
3893: CURSOR c_parent_role_relate_cur(l_parent_group_id IN NUMBER) IS
3894: SELECT rlt.role_relate_id
3895: FROM jtf_rs_role_relations rlt,
3896: jtf_rs_group_members mem
3897: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
3898: AND rlt.role_resource_id = mem.group_member_id
3899: AND nvl(rlt.delete_flag,'N') <> 'Y'
3900: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 4038: FROM jtf_rs_group_members mem,

4034: rlt.start_date_active,
4035: rlt.end_date_active,
4036: rol.admin_flag ,
4037: rol.manager_flag
4038: FROM jtf_rs_group_members mem,
4039: jtf_rs_role_relations rlt,
4040: jtf_rs_roles_B rol
4041: WHERE mem.group_id IN ( select distinct(parent_group_id)
4042: from jtf_rs_groups_denorm

Line 4107: FROM jtf_rs_group_members mem,

4103: rol.admin_flag ,
4104: rol.lead_flag ,
4105: rol.manager_flag,
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

Line 4138: FROM jtf_rs_group_members mem,

4134: rol.admin_flag ,
4135: rol.lead_flag ,
4136: rol.manager_flag,
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