APPS.HR_CURRENCY_PKG SQL Statements

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

Line: 84

  SELECT   DECODE(
             fc.derive_type,
	       'EURO', 'EURO',
		  'EMU', DECODE(
		   SIGN(TRUNC(p_eff_date) - TRUNC(fc.derive_effective)),
		   -1, 'OTHER',
		  'EMU'),
		  'OTHER'),
		  DECODE(
		  fc.derive_type,
		  'EURO', 1,
	          'EMU', fc.derive_factor,
		  'OTHER', -1),
	        NVL(fc.minimum_accountable_unit,
             POWER(10, (-1 * fc.precision)))
	  INTO     p_currency_type,
                p_conversion_rate,
                p_mau
	  FROM     fnd_currencies fc
	 WHERE     fc.currency_code = p_currency;

Line: 164

 SELECT     currency_code
 INTO       euro_code
 FROM       FND_CURRENCIES
 WHERE derive_type = 'EURO';

Line: 200

     select conversion_type
     into   l_conversion_type
     from gl_daily_conversion_types
     where user_conversion_type = p_rate_type;

Line: 272

        select conversion_type
        into l_conversion_type
        from gl_daily_conversion_types
        where user_conversion_type = l_value;

Line: 328

        SELECT    conversion_rate
        INTO      rate
        FROM      GL_DAILY_RATES
        WHERE     from_currency = p_from_currency
        AND  to_currency     = p_to_currency
        AND  conversion_date = trunc(p_conversion_date)
        AND  conversion_type = p_conversion_type;

Line: 770

    select fcu.derive_type
         , fcu.derive_effective
         , fcu.derive_factor
      from fnd_currencies fcu
     where fcu.currency_code = p_from_currency;

Line: 777

    select NVL(fcu.minimum_accountable_unit, POWER(10, (-1 * fcu.precision)))
      from fnd_currencies fcu
     where fcu.currency_code = 'EUR';