APPS.JTF_RS_ROLE_RELATE_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 43: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)

39: p_new_end_date IN DATE ,
40: p_valid OUT NOCOPY BOOLEAN)
41: is
42:
43: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
44: IS
45: SELECT rsc.start_date_active,
46: rsc.end_date_active
47: FROM jtf_rs_resource_extns rsc

Line 47: FROM jtf_rs_resource_extns rsc

43: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
44: IS
45: SELECT rsc.start_date_active,
46: rsc.end_date_active
47: FROM jtf_rs_resource_extns rsc
48: WHERE rsc.resource_id = ll_resource_id;
49:
50: rsc_rec rsc_cur%rowtype;
51:

Line 289: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

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;
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,

Line 394: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)

390:
391: team_rec team_cur%rowtype;
392:
393:
394: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
395: IS
396: SELECT rsc.start_date_active,
397: rsc.end_date_active
398: FROM jtf_rs_resource_extns rsc

Line 398: FROM jtf_rs_resource_extns rsc

394: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
395: IS
396: SELECT rsc.start_date_active,
397: rsc.end_date_active
398: FROM jtf_rs_resource_extns rsc
399: WHERE rsc.resource_id = ll_resource_id;
400:
401: rsc_rec rsc_cur%rowtype;
402:

Line 1407: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

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;
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,

Line 1492: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)

1488: AND nvl(mem.delete_flag, '0') <> 'Y';
1489:
1490: team_rec team_cur%rowtype;
1491:
1492: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
1493: IS
1494: SELECT rsc.start_date_active,
1495: rsc.end_date_active
1496: FROM jtf_rs_resource_extns rsc

Line 1496: FROM jtf_rs_resource_extns rsc

1492: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
1493: IS
1494: SELECT rsc.start_date_active,
1495: rsc.end_date_active
1496: FROM jtf_rs_resource_extns rsc
1497: WHERE rsc.resource_id = ll_resource_id;
1498:
1499: rsc_rec rsc_cur%rowtype;
1500:

Line 2663: CURSOR chk_grp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,

2659:
2660:
2661: chk_type_rec chk_type_cur%rowtype;
2662:
2663: CURSOR chk_grp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2664: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2665: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2666: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2667: IS

Line 2682: CURSOR chk_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,

2678: AND nvl(rlt.delete_flag, '0') <> 'Y';
2679:
2680: chk_grp_rec chk_grp_cur%rowtype;
2681:
2682: CURSOR chk_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2683: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2684: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2685: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2686: IS