770: -- ----------------------------------------------------------------------------
771: --
772: -- Description:
773: -- Validates that location_id of organization unit is present in
774: -- HR_LOCATIONS_ALL table and valid when not null.
775: --
776: -- Pre-conditions:
777: -- None.
778: --
803: l_exists VARCHAR2(1) := 'N';
804: --
805: cursor csr_location_id IS
806: SELECT 'Y'
807: FROM hr_locations_all
808: WHERE location_id = p_location_id;
809: --
810: BEGIN
811: --