eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_REGISTRY_VALIDATE_V2PUB dependencies on FND_LOOKUP_VALUES

Line 95: FROM fnd_lookup_values

91:
92: CURSOR c_nace
93: IS
94: SELECT 'Y'
95: FROM fnd_lookup_values
96: WHERE lookup_type = p_lookup_type
97: AND replace(lookup_code, '.', '') = replace(p_column_value, '.', '')
98: AND ROWNUM = 1;
99:

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

390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN
392: l_return := FALSE;
393: END;
394: ELSIF UPPER(l_lookup_table) = 'FND_LOOKUP_VALUES' THEN
395: BEGIN
396: SELECT 'Y' INTO l_dummy
397: FROM FND_LOOKUP_VALUES
398: WHERE LOOKUP_TYPE = l_lookup_type

Line 397: FROM FND_LOOKUP_VALUES

393: END;
394: ELSIF UPPER(l_lookup_table) = 'FND_LOOKUP_VALUES' THEN
395: BEGIN
396: SELECT 'Y' INTO l_dummy
397: FROM FND_LOOKUP_VALUES
398: WHERE LOOKUP_TYPE = l_lookup_type
399: AND LOOKUP_CODE = l_lookup_code
400: AND (ENABLED_FLAG = 'Y' AND
401: TRUNC(SYSDATE) BETWEEN