[Home] [Help]
1245: p_effective_date => p_effective_date);
1246: End if;
1247:
1248: hr_utility.set_location(l_proc,25);
1249: ghr_api.sf52_from_data_elements
1250: (p_person_id => p_person_id
1251: ,p_assignment_id => l_pa_request_rec.employee_assignment_id
1252: ,p_effective_date => p_effective_date
1253: ,p_altered_pa_request_id => null
1380: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1381:
1382: hr_utility.set_location(l_proc,45);
1383: hr_utility.set_location(l_proc,50);
1384: l_pa_request_rec.agency_code := ghr_api.get_position_agency_code_pos
1385: (p_position_id => p_position_id
1386: ,p_business_group_id => p_business_group_id
1387: ,p_effective_date => p_effective_date);
1388:
1408: l_pa_request_rec.service_comp_date := fnd_date.canonical_to_date(l_scd_leave);
1409:
1410: -- get education details
1411: hr_utility.set_location(l_proc,70);
1412: ghr_api.return_education_Details
1413: (p_person_id => l_pa_request_rec.person_id,
1414: p_effective_date => l_pa_request_rec.effective_date,
1415: p_education_level => l_pa_request_rec.education_level,
1416: p_academic_discipline => l_pa_request_rec.academic_discipline,
1443: );
1444: -- get fegli,retirement_plan
1445:
1446: hr_utility.set_location(l_proc,901);
1447: ghr_api.retrieve_element_entry_value
1448: (p_element_name => 'FEGLI'
1449: ,p_input_value_name => 'FEGLI'
1450: ,p_assignment_id => l_pa_request_rec.employee_assignment_id
1451: ,p_effective_date => l_pa_request_rec.effective_date
1459: );
1460:
1461: --retirement_plan
1462: hr_utility.set_location(l_proc,100);
1463: ghr_api.retrieve_element_entry_value
1464: (p_element_name => 'Retirement Plan'
1465: ,p_input_value_name => 'Plan'
1466: ,p_assignment_id => l_pa_request_rec.employee_assignment_id
1467: ,p_effective_date => l_pa_request_rec.effective_date
1474: ,'GHR_US_RETIREMENT_PLAN'
1475: ,l_pa_request_rec.retirement_plan
1476: );
1477: -- Get FEHB Plan
1478: ghr_api.retrieve_element_entry_value
1479: ( p_element_name => 'Health Benefits'
1480: ,p_input_value_name => 'Health Plan'
1481: ,p_assignment_id => l_pa_request_rec.employee_assignment_id
1482: ,p_effective_date => trunc(l_pa_request_rec.effective_date)
1899: AND ppt.system_person_type IN ('EMP','EMP_APL')
1900: AND paf.organization_id = hou.organization_id
1901: AND paf.position_id is not null
1902: and paf.business_group_id = nvl(p_business_group_id,paf.business_group_id)
1903: AND substr(ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id,l_eff_date),1,2) = nvl(l_agency,substr(ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id,l_eff_date),1,2))
1904: ORDER BY ppf.person_id;
1905: --
1906: -- Check assignment_status_type
1907: --
1952: AND upper(past.user_status) in ('FURLOUGH','FURLOUGH NTE')
1953: AND paf.organization_id = hou.organization_id
1954: AND paf.position_id is not null
1955: and paf.business_group_id = nvl(p_business_group_id,paf.business_group_id)
1956: AND substr(ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id,l_eff_date),1,2) = nvl(l_agency,substr(ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id,l_eff_date),1,2))
1957: ORDER BY ppf.person_id;
1958:
1959: CURSOR get_rpa_type (p_person_id number,p_assignment_id number) IS
1960: SELECT par.rpa_type,par.effective_date from ghr_pa_requests par