APPS.FUN_RULE_VALIDATE_PKG dependencies on FND_LOOKUP_VALUES

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

246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
248: l_return := FALSE;
249: END;
250: ELSIF UPPER(l_lookup_table) = 'FND_LOOKUP_VALUES' THEN
251: BEGIN
252: SELECT 'Y' INTO l_dummy
253: FROM FND_LOOKUP_VALUES
254: WHERE LOOKUP_TYPE = l_lookup_type

Line 253: FROM FND_LOOKUP_VALUES

249: END;
250: ELSIF UPPER(l_lookup_table) = 'FND_LOOKUP_VALUES' THEN
251: BEGIN
252: SELECT 'Y' INTO l_dummy
253: FROM FND_LOOKUP_VALUES
254: WHERE LOOKUP_TYPE = l_lookup_type
255: AND LOOKUP_CODE = l_lookup_code
256: AND (ENABLED_FLAG = 'Y' AND
257: TRUNC(SYSDATE) BETWEEN

Line 488: FROM fnd_lookup_values

484: IS
485: CURSOR c1
486: IS
487: SELECT 'Y'
488: FROM fnd_lookup_values
489: WHERE lookup_type = p_lookup_type
490: AND lookup_code = p_column_value
491: AND ROWNUM = 1;
492:

Line 1865: p_lookup_table IN VARCHAR2 DEFAULT 'FND_LOOKUP_VALUES',

1861:
1862:
1863: PROCEDURE validate_lookup (
1864: p_column IN VARCHAR2,
1865: p_lookup_table IN VARCHAR2 DEFAULT 'FND_LOOKUP_VALUES',
1866: p_lookup_type IN VARCHAR2,
1867: p_column_value IN VARCHAR2,
1868: x_return_status IN OUT NOCOPY VARCHAR2
1869: ) IS