SELECT C.CURRENCY_CODE , T.NAME FROM FND_CURRENCIES_TL T , FND_CURRENCIES C WHERE C.ENABLED_FLAG = 'Y' AND C.CURRENCY_FLAG = 'Y' AND TRUNC(NVL(C.START_DATE_ACTIVE , SYSDATE)) <= TRUNC(SYSDATE) AND TRUNC(NVL(C.END_DATE_ACTIVE , SYSDATE)) >= TRUNC(SYSDATE) AND C.CURRENCY_CODE = T.CURRENCY_CODE AND T.LANGUAGE = USERENV('LANG')