DBA Data[Home] [Help]

APPS.GHR_GHRWS52L dependencies on HR_LOCATIONS

Line 73: -- l_prior_location_id hr_locations.location_id%type

69: l_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
70: l_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
71: l_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;
72: l_Prior_Basic_Pay varchar2(30); -- ghr_pa_requests.FROM_BASIC_PAY%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;

Line 163: , hr_locations loc

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
167: and lei.location_id = loc.location_id