APPS.PER_VACANCIES_PKG dependencies on HR_LOCATIONS

Line 724: FROM HR_LOCATIONS HL

720: P_location_id NUMBER) IS
721:
722: CURSOR c_loc_chk IS
723: SELECT 1
724: FROM HR_LOCATIONS HL
725: WHERE HL.LOCATION_ID = P_location_id
726: AND P_vac_date_from > nvl(HL.INACTIVE_DATE,P_end_of_time);
727:
728: --