[Home] [Help]
38: l_citizenship ghr_pa_requests.CITIZENSHIP%type;
39: l_credit_mil_svc per_people_extra_info.pei_information5%type;
40: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
41: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
42: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;
43: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
44: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
45: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
46: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
58: l_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;
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;
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
167: and lei.location_id = loc.location_id
168: and lei.information_type = 'GHR_US_LOC_INFORMATION'