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 50: jtf_rs_roles_B rol,

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

Line 84: jtf_rs_roles_B rol,

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

Line 170: jtf_rs_roles_B rol

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

Line 227: jtf_rs_roles_b rol

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

Line 257: jtf_rs_roles_b rol

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

Line 314: jtf_rs_roles_b rol,

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

Line 1180: jtf_rs_roles_B rol,

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

Line 1214: jtf_rs_roles_B rol,

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

Line 1284: jtf_rs_roles_B rol

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

Line 1338: jtf_rs_roles_b rol

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

Line 1368: jtf_rs_roles_b rol

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

Line 1422: jtf_rs_roles_b rol,

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

Line 3036: jtf_rs_roles_B rol,

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

Line 3116: jtf_rs_roles_b rol

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

Line 3146: jtf_rs_roles_b rol

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

Line 3542: jtf_rs_roles_B rol,

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

Line 3570: jtf_rs_roles_B rol,

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

Line 4027: jtf_rs_roles_B rol

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

Line 4053: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

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,
4055: p_end_date_active DATE,
4056: p_admin_flag JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
4057: p_manager_flag JTF_RS_ROLES_B.MANAGER_FLAG%TYPE);

Line 4056: p_admin_flag JTF_RS_ROLES_B.ADMIN_FLAG%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,
4055: p_end_date_active DATE,
4056: p_admin_flag JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
4057: p_manager_flag JTF_RS_ROLES_B.MANAGER_FLAG%TYPE);
4058:
4059:
4060: TYPE mgr_tab_type IS TABLE OF mgr_type INDEX BY BINARY_INTEGER;

Line 4057: p_manager_flag JTF_RS_ROLES_B.MANAGER_FLAG%TYPE);

4053: p_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
4054: p_start_date_active DATE,
4055: p_end_date_active DATE,
4056: p_admin_flag JTF_RS_ROLES_B.ADMIN_FLAG%TYPE,
4057: p_manager_flag JTF_RS_ROLES_B.MANAGER_FLAG%TYPE);
4058:
4059:
4060: TYPE mgr_tab_type IS TABLE OF mgr_type INDEX BY BINARY_INTEGER;
4061: l_mgr_rec MGR_TAB_TYPE;

Line 4096: jtf_rs_roles_B rol,

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

Line 4127: jtf_rs_roles_B rol,

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