DBA Data[Home] [Help]

APPS.QRM_CALCULATORS_P dependencies on XTR_SPOT_RATES

Line 1403: FROM xtr_spot_rates

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)

Line 1406: FROM xtr_spot_rates

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);