DBA Data[Home] [Help]

APPS.HZ_UTILITY_V2PUB dependencies on SO_LOOKUPS

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

327: EXCEPTION
328: WHEN NO_DATA_FOUND THEN
329: l_return := FALSE;
330: END;
331: ELSIF UPPER( l_lookup_table ) = 'SO_LOOKUPS' THEN
332: BEGIN
333: SELECT meaning INTO x_lookup_meaning
334: FROM SO_LOOKUPS
335: WHERE LOOKUP_TYPE = l_lookup_type

Line 334: FROM SO_LOOKUPS

330: END;
331: ELSIF UPPER( l_lookup_table ) = 'SO_LOOKUPS' THEN
332: BEGIN
333: SELECT meaning INTO x_lookup_meaning
334: FROM SO_LOOKUPS
335: WHERE LOOKUP_TYPE = l_lookup_type
336: AND LOOKUP_CODE = l_lookup_code
337: AND ( ENABLED_FLAG = 'Y' AND
338: TRUNC( SYSDATE ) BETWEEN

Line 1016: * SO_LOOKUPS

1012: * p_column Column name you want to validate.
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

Line 1641: * SO_LOOKUPS

1637: * IN:
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