DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on HR_LOCATIONS

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

2922: return T;
2923: END IF;
2924:
2925: --Bug 6270813, the ship to location LOV on the move orders form fetches locations
2926: --from both HR_LOCATIONS and HZ_LOCATIONS tables, hence added an exception in the
2927: --HR_LOCATIONS query and have put another query for checking the location in HZ_LOCATIONS.
2928:
2929: BEGIN
2930:

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

2923: END IF;
2924:
2925: --Bug 6270813, the ship to location LOV on the move orders form fetches locations
2926: --from both HR_LOCATIONS and HZ_LOCATIONS tables, hence added an exception in the
2927: --HR_LOCATIONS query and have put another query for checking the location in HZ_LOCATIONS.
2928:
2929: BEGIN
2930:
2931: SELECT 'valid'

Line 2933: FROM HR_LOCATIONS

2929: BEGIN
2930:
2931: SELECT 'valid'
2932: INTO l_dummy
2933: FROM HR_LOCATIONS
2934: WHERE LOCATION_ID = p_hr_location;
2935:
2936: EXCEPTION
2937: WHEN NO_DATA_FOUND THEN