DBA Data[Home] [Help]

APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on FND_LOOKUP_VALUES

Line 12303: ELSIF UPPER( l_lookup_table ) = 'FND_LOOKUP_VALUES' THEN

12299: EXCEPTION
12300: WHEN NO_DATA_FOUND THEN
12301: l_return := FALSE;
12302: END;
12303: ELSIF UPPER( l_lookup_table ) = 'FND_LOOKUP_VALUES' THEN
12304: BEGIN
12305: SELECT 'Y' INTO l_dummy
12306: FROM FND_LOOKUP_VALUES
12307: WHERE LOOKUP_TYPE = l_lookup_type

Line 12306: FROM FND_LOOKUP_VALUES

12302: END;
12303: ELSIF UPPER( l_lookup_table ) = 'FND_LOOKUP_VALUES' THEN
12304: BEGIN
12305: SELECT 'Y' INTO l_dummy
12306: FROM FND_LOOKUP_VALUES
12307: WHERE LOOKUP_TYPE = l_lookup_type
12308: AND LOOKUP_CODE = l_lookup_code
12309: AND ( ENABLED_FLAG = 'Y' AND
12310: TRUNC( SYSDATE ) BETWEEN