DBA Data[Home] [Help]

APPS.HZ_UTILITY_V2PUB dependencies on OE_SHIP_METHODS_V

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

343: EXCEPTION
344: WHEN NO_DATA_FOUND THEN
345: l_return := FALSE;
346: END;
347: ELSIF UPPER( l_lookup_table ) = 'OE_SHIP_METHODS_V' THEN
348: BEGIN
349: SELECT meaning INTO x_lookup_meaning
350: FROM OE_SHIP_METHODS_V
351: WHERE LOOKUP_TYPE = l_lookup_type

Line 350: FROM OE_SHIP_METHODS_V

346: END;
347: ELSIF UPPER( l_lookup_table ) = 'OE_SHIP_METHODS_V' THEN
348: BEGIN
349: SELECT meaning INTO x_lookup_meaning
350: FROM OE_SHIP_METHODS_V
351: WHERE LOOKUP_TYPE = l_lookup_type
352: AND LOOKUP_CODE = l_lookup_code
353: AND ( ENABLED_FLAG = 'Y' AND
354: TRUNC( SYSDATE ) BETWEEN

Line 1017: * OE_SHIP_METHODS_V

1013: * p_lookup_table Table/view name you want to validate against to.
1014: * For now, we are supporting
1015: * AR_LOOKUPS
1016: * SO_LOOKUPS
1017: * OE_SHIP_METHODS_V
1018: * FND_LOOKUP_VALUES
1019: * Default value is AR_LOOKUPS
1020: * p_lookup_type FND lookup type
1021: * p_column_value Column value

Line 1642: * OE_SHIP_METHODS_V

1638: * p_lookup_table Table/view name you want to validate against to.
1639: * For now, we are supporting
1640: * AR_LOOKUPS
1641: * SO_LOOKUPS
1642: * OE_SHIP_METHODS_V
1643: * FND_LOOKUP_VALUES
1644: * Default value is AR_LOOKUPS
1645: * p_lookup_type FND lookup type
1646: * p_lookup_code FND lookup code