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_ROLE_RELATE_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 60: jtf_rs_group_members mem

56: select rlt.role_relate_id,
57: rlt.start_date_active,
58: rlt.end_date_active
59: from jtf_rs_role_relations rlt,
60: jtf_rs_group_members mem
61: where mem.resource_id = p_resource_id
62: and nvl(mem.delete_flag, 'N') <> 'Y'
63: and rlt.role_resource_id = mem.group_member_id
64: and rlt.role_id = p_role_id --added vide bug#2474811

Line 282: CURSOR grp_mem_cur(l_grp_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)

278: FROM jtf_rs_team_members
279: WHERE team_member_id = l_team_member_id;
280:
281:
282: CURSOR grp_mem_cur(l_grp_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
283: IS
284: SELECT resource_id
285: FROM jtf_rs_group_members
286: WHERE group_member_id = l_grp_member_id;

Line 285: FROM jtf_rs_group_members

281:
282: CURSOR grp_mem_cur(l_grp_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
283: IS
284: SELECT resource_id
285: FROM jtf_rs_group_members
286: WHERE group_member_id = l_grp_member_id;
287:
288: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
289: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;

Line 348: CURSOR group_cur(ll_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)

344: AND nvl(delete_flag, 'N') <> 'Y';
345:
346: check_date_rec check_date_cur%rowtype;
347:
348: CURSOR group_cur(ll_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
349: IS
350: SELECT grp.start_date_active,
351: grp.end_date_active
352: FROM jtf_rs_groups_b grp,

Line 353: jtf_rs_group_members mem

349: IS
350: SELECT grp.start_date_active,
351: grp.end_date_active
352: FROM jtf_rs_groups_b grp,
353: jtf_rs_group_members mem
354: WHERE mem.group_member_id = ll_member_id
355: AND mem.group_id = grp.group_id;
356:
357: group_rec group_cur%rowtype;

Line 403: CURSOR c_exclusive_group_check_cur(l_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,

399: rsc_rec rsc_cur%rowtype;
400:
401:
402: --exclusive flag check cursor
403: CURSOR c_exclusive_group_check_cur(l_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
404: l_start_date_active DATE,
405: L_end_date_active DATE)
406: IS
407: SELECT 'X'

Line 410: jtf_rs_group_members GM1,

406: IS
407: SELECT 'X'
408: FROM jtf_rs_groups_b G1,
409: jtf_rs_groups_b G2,
410: jtf_rs_group_members GM1,
411: jtf_rs_group_members GM2,
412: jtf_rs_group_usages GU1,
413: jtf_rs_group_usages GU2,
414: jtf_rs_role_relations RR1

Line 411: jtf_rs_group_members GM2,

407: SELECT 'X'
408: FROM jtf_rs_groups_b G1,
409: jtf_rs_groups_b G2,
410: jtf_rs_group_members GM1,
411: jtf_rs_group_members GM2,
412: jtf_rs_group_usages GU1,
413: jtf_rs_group_usages GU2,
414: jtf_rs_role_relations RR1
415: /* commented the below line to improve the performance. We are not using this table in the select statement. */

Line 448: from jtf_rs_group_members mem,

444:
445: cursor get_group_cur(l_role_relate_id number)
446: is
447: select mem.group_id
448: from jtf_rs_group_members mem,
449: jtf_rs_role_relations rel
450: where rel.role_relate_id = l_role_relate_id
451: and rel.role_resource_id = mem.group_member_id;
452:

Line 1386: CURSOR grp_mem_cur(l_grp_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)

1382: WHERE team_member_id = l_team_member_id
1383: AND nvl(delete_flag, '0') <> 'Y';
1384:
1385:
1386: CURSOR grp_mem_cur(l_grp_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
1387: IS
1388: SELECT resource_id
1389: FROM jtf_rs_group_members
1390: WHERE group_member_id = l_grp_member_id

Line 1389: FROM jtf_rs_group_members

1385:
1386: CURSOR grp_mem_cur(l_grp_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
1387: IS
1388: SELECT resource_id
1389: FROM jtf_rs_group_members
1390: WHERE group_member_id = l_grp_member_id
1391: AND nvl(delete_flag, '0') <> 'Y';
1392:
1393: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

Line 1453: CURSOR group_cur(ll_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)

1449:
1450:
1451: check_date_rec check_date_cur%rowtype;
1452:
1453: CURSOR group_cur(ll_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
1454: IS
1455: SELECT grp.start_date_active,
1456: grp.end_date_active
1457: FROM jtf_rs_groups_b grp,

Line 1458: jtf_rs_group_members mem

1454: IS
1455: SELECT grp.start_date_active,
1456: grp.end_date_active
1457: FROM jtf_rs_groups_b grp,
1458: jtf_rs_group_members mem
1459: WHERE mem.group_member_id = ll_member_id
1460: AND mem.group_id = grp.group_id
1461: AND nvl(mem.delete_flag, '0') <> 'Y';
1462:

Line 1507: CURSOR c_exclusive_group_check_cur(l_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,

1503:
1504: team_dt_rec team_dt_cur%rowtype;
1505:
1506: --exclusive flag check cursor
1507: CURSOR c_exclusive_group_check_cur(l_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
1508: l_start_date_active DATE,
1509: L_end_date_active DATE)
1510: IS
1511: SELECT 'X'

Line 1514: jtf_rs_group_members GM1,

1510: IS
1511: SELECT 'X'
1512: FROM jtf_rs_groups_b G1,
1513: jtf_rs_groups_b G2,
1514: jtf_rs_group_members GM1,
1515: jtf_rs_group_members GM2,
1516: jtf_rs_group_usages GU1,
1517: jtf_rs_group_usages GU2,
1518: jtf_rs_role_relations RR1

Line 1515: jtf_rs_group_members GM2,

1511: SELECT 'X'
1512: FROM jtf_rs_groups_b G1,
1513: jtf_rs_groups_b G2,
1514: jtf_rs_group_members GM1,
1515: jtf_rs_group_members GM2,
1516: jtf_rs_group_usages GU1,
1517: jtf_rs_group_usages GU2,
1518: jtf_rs_role_relations RR1
1519: /* commented the below line to improve the performance. We are not using this table in the select statement. */

Line 1577: FROM jtf_rs_group_members mem,

1573: L_end_date_active DATE ,
1574: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE)
1575: IS
1576: SELECT rlt.role_relate_id
1577: FROM jtf_rs_group_members mem,
1578: jtf_rs_role_relations rlt
1579: WHERE mem.resource_id = l_resource_id
1580: AND nvl(mem.delete_flag, 'N') <> 'Y'
1581: AND mem.group_member_id = rlt.role_resource_id

Line 1597: from jtf_rs_group_members mem,

1593:
1594: cursor get_group_cur(l_role_relate_id number)
1595: is
1596: select mem.group_id
1597: from jtf_rs_group_members mem,
1598: jtf_rs_role_relations rel
1599: where rel.role_relate_id = l_role_relate_id
1600: and rel.role_resource_id = mem.group_member_id;
1601:

Line 2644: jtf_rs_group_members mem

2640: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2641: IS
2642: SELECT 'x'
2643: FROM jtf_rs_role_relations rlt,
2644: jtf_rs_group_members mem
2645: WHERE mem.resource_id = l_resource_id
2646: AND rlt.role_resource_id = mem.group_member_id
2647: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
2648: AND rlt.role_id = l_role_id

Line 2719: from jtf_rs_group_members mem,

2715:
2716: cursor get_group_cur(l_role_relate_id number)
2717: is
2718: select mem.group_id
2719: from jtf_rs_group_members mem,
2720: jtf_rs_role_relations rel
2721: where rel.role_relate_id = l_role_relate_id
2722: and rel.role_resource_id = mem.group_member_id;
2723: