FND Design Data [Home] [Help]

View: BEN_CWB_CURRENCY_LOV_V

Product: BEN - Advanced Benefits
Description:
Implementation/DBA Data: ViewAPPS.BEN_CWB_CURRENCY_LOV_V
View Text

SELECT CURRENCY_CODE ID
, CURRENCY_CODE || ' - ' || NAME VALUE
FROM FND_CURRENCIES_VL
WHERE ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE)
AND CURRENCY_FLAG = 'Y'

Columns

Name
ID
VALUE