[Home] [Help]
59: l_health_plan varchar2(30);
60: l_Handicap per_people_extra_info.pei_information11%type;
61: l_Indiv_Award ghr_pa_request_extra_info.rei_information6%type;
62: --l_locality_pay_area hr_location_extra_info.lei_information4%type;
63: l_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
64: l_Occupation_code ghr_pa_requests.to_occ_code%type;
65: -- l_Occupation_code per_position_extra_info.poei_information6%type;
66: l_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
67: l_Organ_Component per_position_extra_info.poei_information5%type;
73: -- l_prior_location_id hr_locations.location_id%type
74: l_prior_duty_station ghr_duty_stations_f.Duty_Station_Code%type;
75: l_Prior_Grade_Or_Level per_grade_definitions.segment2%type;
76: l_Prior_Locality_Adj varchar2(30); --ghr_pa_requests.FROM_LOCALITY_ADJ%type;
77: l_prior_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
78: l_Prior_Occupation_code per_job_definitions.segment1%type;
79: l_Prior_Pay_Basis per_position_extra_info.poei_information6%type;
80: l_Prior_Pay_Plan per_grade_definitions.segment1%type;
81: l_Prior_Pay_Rate_Det_Code per_assignment_extra_info.aei_information6%type;
136: CURSOR cur_dutystation IS
137: select dst.duty_station_code
138: , lpa.locality_pay_area_code
139: from ghr_duty_stations_f dst
140: , ghr_locality_pay_areas_f lpa
141: where dst.LOCALITY_PAY_AREA_ID = lpa.LOCALITY_PAY_AREA_ID
142: and dst.DUTY_STATION_ID = p_loc_info.duty_station_id
143: and nvl(p_pa_request_rec.effective_date,trunc(sysdate))
144: between dst.effective_start_date and dst.effective_end_date
158: CURSOR cur_prior_dutystation IS
159: select dst.duty_station_code
160: , lpa.locality_pay_area_code
161: from ghr_duty_stations_f dst
162: , ghr_locality_pay_areas_f lpa
163: , hr_locations loc
164: , hr_location_extra_info lei
165: where
166: loc.location_id = p_sf52_from_data.duty_station_location_id