APPS.GL_CURRENCY_API SQL Statements

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

Line: 39

     SELECT decode( derive_type,
  	            'EURO', 'EURO',
	            'EMU', decode( sign( trunc(x_eff_date) -
					 trunc(derive_effective)),
	  	                   -1, 'OTHER',
			           'EMU'),
                    'OTHER' ),
            decode( derive_type, 'EURO', 1,
		  	         'EMU', derive_factor,
		  	         'OTHER', -1 ),
	    nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
     INTO   x_currency_type,
	    x_conversion_rate,
	    x_mau
     FROM   FND_CURRENCIES
     WHERE  currency_code = x_currency;

Line: 103

           SELECT old_currency,
                  replacement_currency,
                  fixed_conversion_rate
           FROM   GL_FIXED_CONV_RATES
           WHERE  old_currency IN (l_from_curr,l_to_curr)
           AND    effective_start_date <= trunc(l_eff_date)
           ORDER BY DECODE(old_currency, l_from_curr,0,1);

Line: 305

     SELECT 	conversion_rate
     INTO   	rate
     FROM 	GL_DAILY_RATES
     WHERE	from_currency = l_from_currency
     AND	to_currency = l_to_currency
     AND	conversion_date = trunc(x_conversion_date)
     AND	conversion_type = x_conversion_type;

Line: 356

      SELECT conversion_rate
      FROM   GL_DAILY_RATES
      WHERE  from_currency   = g_from_currency
      AND    to_currency     = g_to_currency
      AND    conversion_type = x_conversion_type
      AND    conversion_date BETWEEN
		( decode( sign (x_max_roll_days),
			  1, trunc(x_conversion_date) - x_max_roll_days,
			  -1, trunc(to_date('1000/01/01', 'YYYY/MM/DD'))))
		AND trunc(x_conversion_date)
      ORDER BY conversion_date DESC;

Line: 461

           SELECT 'EXIST'
           FROM   GL_FIXED_CONV_RATES
           WHERE  old_currency IN (l_from_curr,l_to_curr)
           AND    ((old_currency = l_from_curr
                      AND replacement_currency = l_to_curr)
                  OR  (replacement_currency = l_from_curr
                      AND old_currency = l_to_curr))
           AND    effective_start_date <= trunc(l_eff_date)
           AND ROWNUM =1;

Line: 554

           SELECT 'EXIST'
           FROM   GL_FIXED_CONV_RATES
           WHERE  old_currency IN (l_from_curr,l_to_curr)
           AND    ((old_currency = l_from_curr
                      AND replacement_currency = l_to_curr)
                  OR  (replacement_currency = l_from_curr
                      AND old_currency = l_to_curr))
           AND    effective_start_date <= trunc(l_eff_date)
           AND ROWNUM =1;

Line: 628

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

Line: 777

     SELECT 	currency_code
     INTO	to_currency
     FROM	GL_LEDGERS
     WHERE	ledger_id = x_set_of_books_id;

Line: 1038

     SELECT 	currency_code
     INTO	to_currency
     FROM	GL_LEDGERS
     WHERE	ledger_id = x_set_of_books_id;

Line: 1311

     SELECT 	currency_code
     INTO	to_currency
     FROM	GL_LEDGERS
     WHERE	ledger_id = x_set_of_books_id;

Line: 1453

	SELECT 	derive_type, derive_effective
	INTO 	derive_type, derive_effective
	FROM	fnd_currencies
	WHERE	currency_code = curr_code;

Line: 1468

		SELECT 	DECODE(SIGN(trunc(derive_effective) -
	                            trunc(GPS.end_date)), 1,
			'OTHER',
			DECODE (SIGN(trunc(GPS.start_date) -
	                             trunc(derive_effective)), 1,
			'EMU',
			'INTER'))
		INTO	derive_type
		FROM	gl_period_statuses GPS
		WHERE 	GPS.application_id = 101
		AND	GPS.ledger_id = ledger_id
		AND	GPS.period_name = period;

Line: 1680

     SELECT 	currency_code
     INTO	to_currency
     FROM	GL_LEDGERS
     WHERE	ledger_id = x_set_of_books_id;

Line: 1789

     SELECT 	currency_code
     INTO	to_currency
     FROM	GL_LEDGERS
     WHERE	ledger_id = x_set_of_books_id;

Line: 1900

     SELECT 	currency_code
     INTO	to_currency
     FROM	GL_LEDGERS
     WHERE	ledger_id = x_set_of_books_id;

Line: 2088

     SELECT 	currency_code
     INTO	to_currency
     FROM	GL_LEDGERS
     WHERE	ledger_id = x_set_of_books_id;

Line: 2205

     SELECT 	currency_code
     INTO	to_currency
     FROM	GL_LEDGERS
     WHERE	ledger_id = x_set_of_books_id;

Line: 2315

     SELECT 	currency_code
     INTO	to_currency
     FROM	GL_LEDGERS
     WHERE	ledger_id = x_set_of_books_id;

Line: 2455

    SELECT 	currency_code
    INTO	to_currency
    FROM	GL_LEDGERS
    WHERE	ledger_id = x_set_of_books_id;