DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on HZ_LOCATIONS

Line 2792: --from both HR_LOCATIONS and HZ_LOCATIONS tables, hence added an exception in the

2788: return T;
2789: END IF;
2790:
2791: --Bug 6270813, the ship to location LOV on the move orders form fetches locations
2792: --from both HR_LOCATIONS and HZ_LOCATIONS tables, hence added an exception in the
2793: --HR_LOCATIONS query and have put another query for checking the location in HZ_LOCATIONS.
2794:
2795: BEGIN
2796:

Line 2793: --HR_LOCATIONS query and have put another query for checking the location in HZ_LOCATIONS.

2789: END IF;
2790:
2791: --Bug 6270813, the ship to location LOV on the move orders form fetches locations
2792: --from both HR_LOCATIONS and HZ_LOCATIONS tables, hence added an exception in the
2793: --HR_LOCATIONS query and have put another query for checking the location in HZ_LOCATIONS.
2794:
2795: BEGIN
2796:
2797: SELECT 'valid'

Line 2807: FROM HZ_LOCATIONS

2803: WHEN NO_DATA_FOUND THEN
2804:
2805: SELECT 'valid'
2806: INTO l_dummy
2807: FROM HZ_LOCATIONS
2808: WHERE LOCATION_ID = p_hr_location;
2809: END;
2810:
2811: RETURN T;