DBA Data[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)