[Home] [Help]
38: l_credit_mil_svc per_people_extra_info.pei_information5%type;
39: l_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
40: l_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
41: l_Duty_Station_ID hr_location_extra_info.lei_information3%type;
42: l_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
43: l_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
44: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
45: l_Employee_Date_of_Birth per_people_f.date_of_birth%type;
46: l_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
69: l_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
70: l_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;
71: l_Prior_Basic_Pay varchar2(30); -- ghr_pa_requests.FROM_BASIC_PAY%type;
72: -- l_prior_location_id hr_locations.location_id%type
73: l_prior_duty_station ghr_duty_stations_f.Duty_Station_Code%type;
74: l_Prior_Grade_Or_Level per_grade_definitions.segment2%type;
75: l_Prior_Locality_Adj varchar2(30); --ghr_pa_requests.FROM_LOCALITY_ADJ%type;
76: l_prior_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
77: l_Prior_Occupation_code per_job_definitions.segment1%type;
130:
131: CURSOR cur_dutystation IS
132: select dst.duty_station_code
133: , lpa.locality_pay_area_code
134: from ghr_duty_stations_f dst
135: , ghr_locality_pay_areas_f lpa
136: where dst.LOCALITY_PAY_AREA_ID = lpa.LOCALITY_PAY_AREA_ID
137: and dst.DUTY_STATION_ID = p_loc_info.duty_station_id
138: and nvl(p_pa_request_rec.effective_date,trunc(sysdate))
152:
153: CURSOR cur_prior_dutystation IS
154: select dst.duty_station_code
155: , lpa.locality_pay_area_code
156: from ghr_duty_stations_f dst
157: , ghr_locality_pay_areas_f lpa
158: , hr_locations loc
159: , hr_location_extra_info lei
160: where