APPS.GHR_ELT_TO_BEN_PKG dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 2127: l_rpa_tsp_status_code ghr_pa_request_extra_info.rei_information15%type;

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:
2131: CURSOR c_future_actions IS

Line 2128: l_rpa_agncy_contrib_elig_date ghr_pa_request_extra_info.rei_information17%type;

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:
2131: CURSOR c_future_actions IS
2132: SELECT pa.pa_request_id,

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

Line 2592: UPDATE ghr_pa_request_extra_info

2588: IF l_update_flag = 1 OR l_elig_date_flag =1 THEN
2589: l_tsp_future_rec_cnt := l_tsp_future_rec_cnt+1;
2590: IF l_update_flag = 1 THEN
2591: l_update_flag := 0;
2592: UPDATE ghr_pa_request_extra_info
2593: SET rei_information15 =l_rpa_tsp_status_code
2594: where information_type='GHR_US_PAR_BENEFITS'
2595: AND pa_request_id = l_pa_request_id;
2596: END IF;

Line 2599: UPDATE ghr_pa_request_extra_info

2595: AND pa_request_id = l_pa_request_id;
2596: END IF;
2597: IF l_elig_date_flag = 1 THEN
2598: l_elig_date_flag:=0;
2599: UPDATE ghr_pa_request_extra_info
2600: SET rei_information17 = fnd_date.date_to_canonical(l_rpa_effective_date)
2601: where information_type='GHR_US_PAR_BENEFITS'
2602: AND pa_request_id = l_pa_request_id;
2603: END IF;