DBA Data[Home] [Help]

APPS.FUN_RULE_VALIDATE_PKG dependencies on OE_SHIP_METHODS_V

Line 232: ELSIF UPPER(l_lookup_table) = 'OE_SHIP_METHODS_V' THEN

228: EXCEPTION
229: WHEN NO_DATA_FOUND THEN
230: l_return := FALSE;
231: END;
232: ELSIF UPPER(l_lookup_table) = 'OE_SHIP_METHODS_V' THEN
233: BEGIN
234: SELECT 'Y' INTO l_dummy
235: FROM OE_SHIP_METHODS_V
236: WHERE LOOKUP_TYPE = l_lookup_type

Line 235: FROM OE_SHIP_METHODS_V

231: END;
232: ELSIF UPPER(l_lookup_table) = 'OE_SHIP_METHODS_V' THEN
233: BEGIN
234: SELECT 'Y' INTO l_dummy
235: FROM OE_SHIP_METHODS_V
236: WHERE LOOKUP_TYPE = l_lookup_type
237: AND LOOKUP_CODE = l_lookup_code
238: AND (ENABLED_FLAG = 'Y' AND
239: TRUNC(SYSDATE) BETWEEN