1399: usd_base_curr_offer_rate ask_rate_comm,
1400: 1/usd_base_curr_offer_rate bid_rate_base,
1401: 1/usd_base_curr_bid_rate ask_rate_base,
1402: currency
1403: FROM xtr_spot_rates
1404: WHERE (rate_date, currency) IN
1405: (SELECT MAX(rate_date), currency
1406: FROM xtr_spot_rates
1407: WHERE currency IN (p_base_ccy)
1402: currency
1403: FROM xtr_spot_rates
1404: WHERE (rate_date, currency) IN
1405: (SELECT MAX(rate_date), currency
1406: FROM xtr_spot_rates
1407: WHERE currency IN (p_base_ccy)
1408: AND currency <> 'USD'
1409: AND trunc(rate_date) <= trunc(p_spot_date)
1410: GROUP BY currency);