APPS.PER_VACANCIES_PKG dependencies on HR_LOCATIONS

Line 737: FROM HR_LOCATIONS HL

733: P_location_id NUMBER) IS
734:
735: CURSOR c_loc_chk IS
736: SELECT 1
737: FROM HR_LOCATIONS HL
738: WHERE HL.LOCATION_ID = P_location_id
739: AND P_vac_date_from > nvl(HL.INACTIVE_DATE,P_end_of_time);
740:
741: --