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.

[Home] [Help]

APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 78: jtf_rs_team_members mem

74: select rlt.role_relate_id,
75: rlt.start_date_active,
76: rlt.end_date_active
77: from jtf_rs_role_relations rlt,
78: jtf_rs_team_members mem
79: where mem.team_resource_id = p_resource_id
80: and mem.resource_type = 'INDIVIDUAL'
81: and nvl(mem.delete_flag, 'N') <> 'Y'
82: and rlt.role_resource_id = mem.team_member_id

Line 274: CURSOR team_mem_cur(l_team_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)

270:
271: l_date_invalid boolean := FALSE;
272:
273:
274: CURSOR team_mem_cur(l_team_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
275: IS
276: SELECT resource_type,
277: team_resource_id
278: FROM jtf_rs_team_members

Line 278: FROM jtf_rs_team_members

274: CURSOR team_mem_cur(l_team_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
275: IS
276: SELECT resource_type,
277: team_resource_id
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)

Line 290: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;

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;
290: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;
291:
292: --changed the date comparison in the cursor 07/07/00
293: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
294: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

Line 382: CURSOR team_cur(ll_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)

378: team_dt_rec team_dt_cur%rowtype;
379:
380:
381:
382: CURSOR team_cur(ll_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
383: IS
384: SELECT tm.start_date_active,
385: tm.end_date_active
386: FROM jtf_rs_teams_b tm,

Line 387: jtf_rs_team_members mem

383: IS
384: SELECT tm.start_date_active,
385: tm.end_date_active
386: FROM jtf_rs_teams_b tm,
387: jtf_rs_team_members mem
388: WHERE mem.team_member_id = ll_member_id
389: AND mem.team_id = tm.team_id;
390:
391: team_rec team_cur%rowtype;

Line 1391: CURSOR team_mem_cur(l_team_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)

1387: l_request number;
1388:
1389: l_valid boolean := TRUE;
1390:
1391: CURSOR team_mem_cur(l_team_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
1392: IS
1393: SELECT resource_type,
1394: team_resource_id
1395: FROM jtf_rs_team_members

Line 1395: FROM jtf_rs_team_members

1391: CURSOR team_mem_cur(l_team_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
1392: IS
1393: SELECT resource_type,
1394: team_resource_id
1395: FROM jtf_rs_team_members
1396: WHERE team_member_id = l_team_member_id
1397: AND nvl(delete_flag, '0') <> 'Y';
1398:
1399:

Line 1408: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;

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;
1408: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;
1409:
1410: --changed the date comparison in the cursor 07/07/00
1411: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1412: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

Line 1480: CURSOR team_cur(ll_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)

1476:
1477: group_rec group_cur%rowtype;
1478:
1479:
1480: CURSOR team_cur(ll_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
1481: IS
1482: SELECT tm.start_date_active,
1483: tm.end_date_active
1484: FROM jtf_rs_teams_b tm,

Line 1485: jtf_rs_team_members mem

1481: IS
1482: SELECT tm.start_date_active,
1483: tm.end_date_active
1484: FROM jtf_rs_teams_b tm,
1485: jtf_rs_team_members mem
1486: WHERE mem.team_member_id = ll_member_id
1487: AND mem.team_id = tm.team_id
1488: AND nvl(mem.delete_flag, '0') <> 'Y';
1489:

Line 1567: FROM jtf_rs_team_members mem,

1563: L_end_date_active DATE ,
1564: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE )
1565: IS
1566: SELECT 'X'
1567: FROM jtf_rs_team_members mem,
1568: jtf_rs_role_relations rlt
1569: WHERE mem.team_resource_id = l_resource_id
1570: AND mem.resource_type = 'INDIVIDUAL'
1571: AND nvl(mem.delete_flag, 'N') <> 'Y'

Line 2689: jtf_rs_team_members mem

2685: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2686: IS
2687: SELECT 'x'
2688: FROM jtf_rs_role_relations rlt,
2689: jtf_rs_team_members mem
2690: WHERE mem.team_resource_id = l_resource_id
2691: AND mem.resource_type <> 'GROUP'
2692: AND rlt.role_resource_id = mem.team_member_id
2693: AND rlt.role_resource_type = 'RS_TEAM_MEMBER'