APPS.AST_RATES_PKG SQL Statements

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

Line: 39

	   select round((x_amount/rate.denominator_rate)*rate.numerator_rate,2),
			rate.conversion_status_flag
			into
			l_converted_amount,
			l_converted_status
        from   as_period_rates rate,
			as_period_days day
        where  rate.from_currency=x_from_currency
	   and    rate.to_currency=x_to_currency
	   and    day.period_name=rate.period_name
	   and    day.period_set_name=l_period_set_name
	   and    day.period_type=l_period_type
	   and    day.period_day=trunc(x_conversion_date);