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:
282: CURSOR grp_mem_cur(l_grp_member_id JTF_RS_GROUP_MEMBERS.GROUP_MEMBER_ID%TYPE)

Line 289: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;

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

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

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

Line 385: jtf_rs_team_members mem

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

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

1373: l_request number;
1374:
1375: l_valid boolean := TRUE;
1376:
1377: CURSOR team_mem_cur(l_team_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
1378: IS
1379: SELECT resource_type,
1380: team_resource_id
1381: FROM jtf_rs_team_members

Line 1381: FROM jtf_rs_team_members

1377: CURSOR team_mem_cur(l_team_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
1378: IS
1379: SELECT resource_type,
1380: team_resource_id
1381: FROM jtf_rs_team_members
1382: WHERE team_member_id = l_team_member_id
1383: AND nvl(delete_flag, '0') <> 'Y';
1384:
1385:

Line 1394: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;

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;
1394: l_team_resource_type JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE;
1395:
1396: --changed the date comparison in the cursor 07/07/00
1397: CURSOR res_role_cur(ll_role_resource_id JTF_RS_ROLE_RELATIONS.ROLE_RESOURCE_ID%TYPE,
1398: ll_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,

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

1462:
1463: group_rec group_cur%rowtype;
1464:
1465:
1466: CURSOR team_cur(ll_member_id JTF_RS_TEAM_MEMBERS.TEAM_MEMBER_ID%TYPE)
1467: IS
1468: SELECT tm.start_date_active,
1469: tm.end_date_active
1470: FROM jtf_rs_teams_b tm,

Line 1471: jtf_rs_team_members mem

1467: IS
1468: SELECT tm.start_date_active,
1469: tm.end_date_active
1470: FROM jtf_rs_teams_b tm,
1471: jtf_rs_team_members mem
1472: WHERE mem.team_member_id = ll_member_id
1473: AND mem.team_id = tm.team_id
1474: AND nvl(mem.delete_flag, '0') <> 'Y';
1475:

Line 1553: FROM jtf_rs_team_members mem,

1549: L_end_date_active DATE ,
1550: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE )
1551: IS
1552: SELECT 'X'
1553: FROM jtf_rs_team_members mem,
1554: jtf_rs_role_relations rlt
1555: WHERE mem.team_resource_id = l_resource_id
1556: AND mem.resource_type = 'INDIVIDUAL'
1557: AND nvl(mem.delete_flag, 'N') <> 'Y'

Line 2663: jtf_rs_team_members mem

2659: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2660: IS
2661: SELECT 'x'
2662: FROM jtf_rs_role_relations rlt,
2663: jtf_rs_team_members mem
2664: WHERE mem.team_resource_id = l_resource_id
2665: AND mem.resource_type <> 'GROUP'
2666: AND rlt.role_resource_id = mem.team_member_id
2667: AND rlt.role_resource_type = 'RS_TEAM_MEMBER'