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 288: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

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

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

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

Line 396: FROM jtf_rs_resource_extns rsc

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

Line 1393: l_rsc_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

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

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

1474: AND nvl(mem.delete_flag, '0') <> 'Y';
1475:
1476: team_rec team_cur%rowtype;
1477:
1478: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
1479: IS
1480: SELECT rsc.start_date_active,
1481: rsc.end_date_active
1482: FROM jtf_rs_resource_extns rsc

Line 1482: FROM jtf_rs_resource_extns rsc

1478: CURSOR rsc_cur(ll_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
1479: IS
1480: SELECT rsc.start_date_active,
1481: rsc.end_date_active
1482: FROM jtf_rs_resource_extns rsc
1483: WHERE rsc.resource_id = ll_resource_id;
1484:
1485: rsc_rec rsc_cur%rowtype;
1486:

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

2633:
2634:
2635: chk_type_rec chk_type_cur%rowtype;
2636:
2637: CURSOR chk_grp_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2638: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2639: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2640: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2641: IS

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

2652: AND nvl(rlt.delete_flag, '0') <> 'Y';
2653:
2654: chk_grp_rec chk_grp_cur%rowtype;
2655:
2656: CURSOR chk_team_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
2657: l_role_id JTF_RS_ROLES_B.ROLE_ID%TYPE,
2658: l_start_date_active JTF_RS_ROLE_RELATIONS.START_DATE_ACTIVE%TYPE,
2659: l_end_date_active JTF_RS_ROLE_RELATIONS.END_DATE_ACTIVE%TYPE)
2660: IS