[Home] [Help]
909: and trunc(sysdate) between effective_start_date and effective_end_date;
910: --
911: cursor c_appln_tracking is
912: select nvl(ORG_INFORMATION11,'N')
913: from HR_ORGANIZATION_INFORMATION
914: where organization_id = l_business_grp_id
915: and org_information_context = 'BG Recruitment';
916: --
917: begin
1006:
1007: cursor c_bg_id is select business_group_id from per_all_assignments_f where assignment_id=p_assignment_id and trunc(sysdate) between effective_start_date and effective_end_date;
1008: cursor c_assgn_details_row is select * from irc_assignment_details_f where assignment_id =p_assignment_id and latest_details='Y';
1009: cursor c_assgn_details is select 1 from irc_assignment_details_f where assignment_id =p_assignment_id and sysdate between effective_start_date and effective_end_Date and latest_details='Y';
1010: cursor c_appln_tracking is select nvl(ORG_INFORMATION11,'N') from HR_ORGANIZATION_INFORMATION where organization_id=l_business_grp_id and org_information_context='BG Recruitment';
1011:
1012: begin
1013:
1014: open c_bg_id;
1313: WHERE pos.position_id=p_position_id;
1314: CURSOR csr_org_fte IS
1315: SELECT fnd_number.canonical_to_number(org.org_information3) normal_hours ,
1316: DECODE(org.org_information4 ,'Y',1 ,'M',12 ,'W',52 ,'D',365 ,1)
1317: FROM HR_ORGANIZATION_INFORMATION org
1318: WHERE org.organization_id =p_organization_id
1319: AND org.organization_id = p_organization_id
1320: AND org.org_information_context(+) = 'Work Day Information';
1321: CURSOR csr_bus_fte IS