APPS.GHR_PA_REQUESTS_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 886: FROM hr_location_extra_info lei

882: ,p_duty_station_id OUT NOCOPY varchar2) IS
883:
884: CURSOR cur_lei IS
885: SELECT lei.lei_information3 duty_station_id
886: FROM hr_location_extra_info lei
887: WHERE lei.location_id = p_location_id
888: AND lei.information_type = 'GHR_US_LOC_INFORMATION';
889:
890: BEGIN

Line 2395: FROM hr_location_extra_info lei, ghr_duty_stations_v ds

2391:
2392:
2393: CURSOR get_duty_station_code IS
2394: select ds.duty_station_code
2395: FROM hr_location_extra_info lei, ghr_duty_stations_v ds
2396: WHERE lei.location_id = l_location_id
2397: AND lei.information_type = 'GHR_US_LOC_INFORMATION'
2398: and to_number(lei.lei_information3) = ds.duty_station_id
2399: and p_effective_date between ds.effective_start_date