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