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_ROLES_B

Line 51: jtf_rs_roles_B rol,

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'
55: AND rlt.role_resource_id = mem.group_member_id

Line 85: jtf_rs_roles_B rol,

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
89: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 171: jtf_rs_roles_B rol

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
174: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
175: AND rlt.role_relate_id <> l_role_relate_id

Line 228: jtf_rs_roles_b rol

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
231: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
232: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 258: jtf_rs_roles_b rol

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
261: AND nvl(rlt.delete_flag,'N') <> 'Y'
262: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 315: jtf_rs_roles_b rol,

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
319: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 1181: jtf_rs_roles_B rol,

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'
1185: AND rlt.role_resource_id = mem.group_member_id

Line 1215: jtf_rs_roles_B rol,

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
1219: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 1285: jtf_rs_roles_B rol

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
1288: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
1289: AND rlt.role_relate_id <> l_role_relate_id

Line 1339: jtf_rs_roles_b rol

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
1342: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
1343: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 1369: jtf_rs_roles_b rol

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
1372: AND nvl(rlt.delete_flag,'N') <> 'Y'
1373: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 1423: jtf_rs_roles_b rol,

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
1427: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 3049: jtf_rs_roles_B rol,

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'
3053: AND rlt.role_resource_id = mem.group_member_id

Line 3129: jtf_rs_roles_b rol

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
3132: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
3133: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 3159: jtf_rs_roles_b rol

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
3162: AND nvl(rlt.delete_flag,'N') <> 'Y'
3163: AND nvl(mem.delete_flag,'N') <> 'Y'

Line 3555: jtf_rs_roles_B rol,

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'
3559: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'

Line 3583: jtf_rs_roles_B rol,

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
3587: AND rlt.role_id = rol.role_id

Line 4040: jtf_rs_roles_B rol

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
4043: where group_id = l_group_id)
4044: /* this has been added to include all parents in the hierarchy */

Line 4066: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

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,
4068: p_end_date_active DATE,
4069: p_admin_flag JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
4070: p_manager_flag JTF_RS_ROLES_B.MANAGER_FLAG%TYPE);

Line 4069: p_admin_flag JTF_RS_ROLES_B.ADMIN_FLAG%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,
4068: p_end_date_active DATE,
4069: p_admin_flag JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
4070: p_manager_flag JTF_RS_ROLES_B.MANAGER_FLAG%TYPE);
4071:
4072:
4073: TYPE mgr_tab_type IS TABLE OF mgr_type INDEX BY BINARY_INTEGER;

Line 4070: p_manager_flag JTF_RS_ROLES_B.MANAGER_FLAG%TYPE);

4066: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
4067: p_start_date_active DATE,
4068: p_end_date_active DATE,
4069: p_admin_flag JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
4070: p_manager_flag JTF_RS_ROLES_B.MANAGER_FLAG%TYPE);
4071:
4072:
4073: TYPE mgr_tab_type IS TABLE OF mgr_type INDEX BY BINARY_INTEGER;
4074: l_mgr_rec MGR_TAB_TYPE;

Line 4109: jtf_rs_roles_B rol,

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
4112: AND mem.group_member_id = rlt.role_resource_id
4113: AND nvl(rlt.delete_flag,'N') <> 'Y'

Line 4140: jtf_rs_roles_B rol,

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
4143: AND mem.group_member_id = rlt.role_resource_id
4144: AND nvl(rlt.delete_flag,'N') <> 'Y'