APPS.EGO_ITEM_COMPARE_PKG dependencies on EGO_VALUE_SET_VALUES_V

Line 349: l_display_val EGO_VALUE_SET_VALUES_V.DISPLAY_NAME%TYPE;

345: p_trade_item_desc IN VARCHAR2
346: )
347: RETURN VARCHAR2 IS
348:
349: l_display_val EGO_VALUE_SET_VALUES_V.DISPLAY_NAME%TYPE;
350:
351: CURSOR c_trade_item_desc(p_trade_item_desc VARCHAR) IS
352: SELECT DISPLAY_NAME
353: FROM EGO_VALUE_SET_VALUES_V

Line 353: FROM EGO_VALUE_SET_VALUES_V

349: l_display_val EGO_VALUE_SET_VALUES_V.DISPLAY_NAME%TYPE;
350:
351: CURSOR c_trade_item_desc(p_trade_item_desc VARCHAR) IS
352: SELECT DISPLAY_NAME
353: FROM EGO_VALUE_SET_VALUES_V
354: WHERE ENABLED_CODE = 'Y'
355: AND ((START_DATE IS NULL) OR (START_DATE IS NOT NULL AND START_DATE <= SYSDATE))
356: AND ((END_DATE IS NULL) OR (END_DATE IS NOT NULL AND END_DATE >= SYSDATE))
357: AND INTERNAL_NAME = p_trade_item_desc;