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