DBA Data[Home] [Help]

APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on SO_LOOKUPS

Line 359: ELSIF UPPER(l_lookup_table) = 'SO_LOOKUPS' THEN

355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN
357: l_return := FALSE;
358: END;
359: ELSIF UPPER(l_lookup_table) = 'SO_LOOKUPS' THEN
360: BEGIN
361: SELECT 'Y' INTO l_dummy
362: FROM SO_LOOKUPS
363: WHERE LOOKUP_TYPE = l_lookup_type

Line 362: FROM SO_LOOKUPS

358: END;
359: ELSIF UPPER(l_lookup_table) = 'SO_LOOKUPS' THEN
360: BEGIN
361: SELECT 'Y' INTO l_dummy
362: FROM SO_LOOKUPS
363: WHERE LOOKUP_TYPE = l_lookup_type
364: AND LOOKUP_CODE = l_lookup_code
365: AND (ENABLED_FLAG = 'Y' AND
366: TRUNC(SYSDATE) BETWEEN