DBA Data[Home] [Help]

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