DBA Data[Home] [Help]

APPS.ASO_MULTI_CURRENCY_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 145

	SELECT decode(derive_type,
                 'EURO', 'EURO',
                 'EMU', decode( sign( trunc(l_effective_date) -
                                      trunc(derive_effective)),
                             -1, 'OTHER', 'EMU'), 'OTHER' ),
		decode(derive_type, 'EURO', 1,
				    'EMU',  derive_factor,
				    'OTHER',-1)
     FROM   FND_CURRENCIES
     WHERE  currency_code = l_currency_code;