APPS.GHR_ELT_TO_BEN_PKG dependencies on GHR_PA_REQUESTS

Line 561: l_emp_num := ghr_pa_requests_pkg2.get_employee_number

557: l_per_err_cnt := l_per_err_cnt + 1 ;
558: --hr_utility.set_location('Error Occured while processing Person ID',75);
559: get_person_name_ssn(l_current_person_id,l_new_effective_date,l_full_name,l_ssn);
560: --Bug # 9329643
561: l_emp_num := ghr_pa_requests_pkg2.get_employee_number
562: (p_person_id => l_current_person_id,
563: p_effective_date => l_new_effective_date);
564: l_log_text := 'System unable to create Benefits EIT for the Person: '||l_full_name||
565: '; Emp No: '||l_emp_num||'; Error: '||sqlerrm;

Line 2126: l_rpa_effective_date ghr_pa_requests.effective_date%type;

2122: and ppf.business_group_id=paf.business_group_id
2123: and ppf.business_group_id= NVL(p_business_group_id,ppf.business_group_id)
2124: AND ghr_api.get_position_agency_code_pos(paf.position_id,paf.business_group_id) like SUBSTR(p_agency_code,1,2)||SUBSTR(p_agency_sub_code,1,2)||'%' ;
2125:
2126: l_rpa_effective_date ghr_pa_requests.effective_date%type;
2127: l_rpa_tsp_status_code ghr_pa_request_extra_info.rei_information15%type;
2128: l_rpa_agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information17%type;
2129: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2130:

Line 2129: l_pa_request_id ghr_pa_requests.pa_request_id%type;

2125:
2126: l_rpa_effective_date ghr_pa_requests.effective_date%type;
2127: l_rpa_tsp_status_code ghr_pa_request_extra_info.rei_information15%type;
2128: l_rpa_agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information17%type;
2129: l_pa_request_id ghr_pa_requests.pa_request_id%type;
2130:
2131: CURSOR c_future_actions IS
2132: SELECT pa.pa_request_id,
2133: pa_ei.rei_information17, pa_ei.rei_information15,

Line 2135: FROM ghr_pa_request_extra_info pa_ei, ghr_pa_requests pa

2131: CURSOR c_future_actions IS
2132: SELECT pa.pa_request_id,
2133: pa_ei.rei_information17, pa_ei.rei_information15,
2134: pa.effective_date
2135: FROM ghr_pa_request_extra_info pa_ei, ghr_pa_requests pa
2136: WHERE pa_ei.information_type='GHR_US_PAR_BENEFITS'
2137: AND pa.noa_family_code in ('APP','CONV_APP')
2138: AND pa.RETIREMENT_PLAN IN('K','L','M','N')
2139: AND pa.effective_date > sysdate