APPS.GMF_GLCOMMON_DB SQL Statements

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

Line: 28

SELECT currency_code
FROM gl_curr_mst
WHERE derive_type = 1 and
      delete_mark = 0;

Line: 161

      SELECT exchange_rate,mul_div_sign
      FROM   GL_XCHG_RTE
      WHERE  from_currency_code   = x_from_currency_code
      AND    to_currency_code     = x_to_currency_code
      AND    rate_type_code = x_rate_type_code
      AND    exchange_rate_date BETWEEN
                decode( sign (x_max_roll_days),
                        -1, trunc(to_date('1000/01/01', 'YYYY/MM/DD')),
                        trunc(x_exchange_rate_date - x_max_roll_days))
                AND x_exchange_rate_date
		and delete_mark = 0
      ORDER BY exchange_rate_date DESC;

Line: 209

     SELECT decode( derive_type,
                    1, 'EURO',
                    2, decode( sign( trunc(x_eff_date) -
                                         trunc(derive_effective)),
                                   -1, 'OTHER',
                                   'EMU'),
                    'OTHER' ),
            decode( derive_type, 1, 1,
                                 2, derive_factor,
                                 0, -1 ),
            nvl( decimal_precision, power( 10, (-1 * decimal_precision)))
     INTO   x_currency_type,
            x_exchange_rate,
            x_mau
     FROM   gl_curr_mst
     WHERE  currency_code = x_currency;