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: --Bug 9652619 To fetch Only Active Group members delete_flag condition is added
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: --Bug 9652619 To fetch Only Active Group members delete_flag condition is added
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: AND NVL(delete_flag,'O') <> 'Y';
288:
289: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

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

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

Line 354: jtf_rs_group_members mem

350: IS
351: SELECT grp.start_date_active,
352: grp.end_date_active
353: FROM jtf_rs_groups_b grp,
354: jtf_rs_group_members mem
355: WHERE mem.group_member_id = ll_member_id
356: AND mem.group_id = grp.group_id
357: AND nvl(mem.delete_flag, '0') <> 'Y';
358:

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

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

Line 412: jtf_rs_group_members GM1,

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

Line 413: jtf_rs_group_members GM2,

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

Line 450: from jtf_rs_group_members mem,

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

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

1396: WHERE team_member_id = l_team_member_id
1397: AND nvl(delete_flag, '0') <> 'Y';
1398:
1399:
1400: CURSOR grp_mem_cur(l_grp_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
1401: IS
1402: SELECT resource_id
1403: FROM jtf_rs_group_members
1404: WHERE group_member_id = l_grp_member_id

Line 1403: FROM jtf_rs_group_members

1399:
1400: CURSOR grp_mem_cur(l_grp_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
1401: IS
1402: SELECT resource_id
1403: FROM jtf_rs_group_members
1404: WHERE group_member_id = l_grp_member_id
1405: AND nvl(delete_flag, '0') <> 'Y';
1406:
1407: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

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

1463:
1464:
1465: check_date_rec check_date_cur%rowtype;
1466:
1467: CURSOR group_cur(ll_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)
1468: IS
1469: SELECT grp.start_date_active,
1470: grp.end_date_active
1471: FROM jtf_rs_groups_b grp,

Line 1472: jtf_rs_group_members mem

1468: IS
1469: SELECT grp.start_date_active,
1470: grp.end_date_active
1471: FROM jtf_rs_groups_b grp,
1472: jtf_rs_group_members mem
1473: WHERE mem.group_member_id = ll_member_id
1474: AND mem.group_id = grp.group_id
1475: AND nvl(mem.delete_flag, '0') <> 'Y';
1476:

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

1517:
1518: team_dt_rec team_dt_cur%rowtype;
1519:
1520: --exclusive flag check cursor
1521: CURSOR c_exclusive_group_check_cur(l_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE,
1522: l_start_date_active DATE,
1523: L_end_date_active DATE)
1524: IS
1525: SELECT 'X'

Line 1528: jtf_rs_group_members GM1,

1524: IS
1525: SELECT 'X'
1526: FROM jtf_rs_groups_b G1,
1527: jtf_rs_groups_b G2,
1528: jtf_rs_group_members GM1,
1529: jtf_rs_group_members GM2,
1530: jtf_rs_group_usages GU1,
1531: jtf_rs_group_usages GU2,
1532: jtf_rs_role_relations RR1

Line 1529: jtf_rs_group_members GM2,

1525: SELECT 'X'
1526: FROM jtf_rs_groups_b G1,
1527: jtf_rs_groups_b G2,
1528: jtf_rs_group_members GM1,
1529: jtf_rs_group_members GM2,
1530: jtf_rs_group_usages GU1,
1531: jtf_rs_group_usages GU2,
1532: jtf_rs_role_relations RR1
1533: /* commented the below line to improve the performance. We are not using this table in the select statement. */

Line 1591: FROM jtf_rs_group_members mem,

1587: L_end_date_active DATE ,
1588: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE)
1589: IS
1590: SELECT rlt.role_relate_id
1591: FROM jtf_rs_group_members mem,
1592: jtf_rs_role_relations rlt
1593: WHERE mem.resource_id = l_resource_id
1594: AND nvl(mem.delete_flag, 'N') <> 'Y'
1595: AND mem.group_member_id = rlt.role_resource_id

Line 1611: from jtf_rs_group_members mem,

1607:
1608: cursor get_group_cur(l_role_relate_id number)
1609: is
1610: select mem.group_id
1611: from jtf_rs_group_members mem,
1612: jtf_rs_role_relations rel
1613: where rel.role_relate_id = l_role_relate_id
1614: and rel.role_resource_id = mem.group_member_id;
1615:

Line 2670: jtf_rs_group_members mem

2666: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2667: IS
2668: SELECT 'x'
2669: FROM jtf_rs_role_relations rlt,
2670: jtf_rs_group_members mem
2671: WHERE mem.resource_id = l_resource_id
2672: AND rlt.role_resource_id = mem.group_member_id
2673: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
2674: AND rlt.role_id = l_role_id

Line 2745: from jtf_rs_group_members mem,

2741:
2742: cursor get_group_cur(l_role_relate_id number)
2743: is
2744: select mem.group_id
2745: from jtf_rs_group_members mem,
2746: jtf_rs_role_relations rel
2747: where rel.role_relate_id = l_role_relate_id
2748: and rel.role_resource_id = mem.group_member_id;
2749: