[Home] [Help]
VIEW: APPS.HR_NCU_CURRENCIES
Source
View Text - Preformatted
SELECT fc.currency_code from fnd_currencies fc WHERE fc.derive_type = 'EMU' and TRUNC(SYSDATE) >= TRUNC(fc.derive_effective)
View Text - HTML Formatted
SELECT FC.CURRENCY_CODE
FROM FND_CURRENCIES FC
WHERE FC.DERIVE_TYPE = 'EMU'
AND TRUNC(SYSDATE) >= TRUNC(FC.DERIVE_EFFECTIVE)