DBA Data[Home] [Help]

APPS.FUN_RULE_VALIDATE_PKG dependencies on SO_LOOKUPS

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

211: EXCEPTION
212: WHEN NO_DATA_FOUND THEN
213: l_return := FALSE;
214: END;
215: ELSIF UPPER(l_lookup_table) = 'SO_LOOKUPS' THEN
216: BEGIN
217: SELECT 'Y' INTO l_dummy
218: FROM SO_LOOKUPS
219: WHERE LOOKUP_TYPE = l_lookup_type

Line 218: FROM SO_LOOKUPS

214: END;
215: ELSIF UPPER(l_lookup_table) = 'SO_LOOKUPS' THEN
216: BEGIN
217: SELECT 'Y' INTO l_dummy
218: FROM SO_LOOKUPS
219: WHERE LOOKUP_TYPE = l_lookup_type
220: AND LOOKUP_CODE = l_lookup_code
221: AND (ENABLED_FLAG = 'Y' AND
222: TRUNC(SYSDATE) BETWEEN