APPS.AS_MC_PKG SQL Statements

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

Line: 239

	SELECT PERIOD_TYPE, START_DATE, END_DATE
	FROM GL_PERIODS
	WHERE PERIOD_SET_NAME = l_calendar
	AND PERIOD_NAME = l_period;

Line: 293

		SELECT CONVERSION_TYPE
		FROM AS_MC_TYPE_MAPPINGS
		WHERE PERIOD_SET_NAME = l_calendar
		AND PERIOD_TYPE = l_period_type;

Line: 727

		SELECT conversion_date
		FROM GL_DAILY_RATES
		WHERE from_currency = l_from_currency
		AND to_currency = l_to_currency
		AND conversion_type = l_conversion_type
		AND conversion_date BETWEEN
			(decode(sign(l_max_roll_days), 1,
			trunc(l_conversion_date)-l_max_roll_days,
			-1, trunc(to_date('1000/01/01','YYYY/MM/DD'))))
		AND trunc(l_conversion_date)
		ORDER BY conversion_date DESC;

Line: 856

	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;