APPS.XTR_MARKET_DATA_P dependencies on XTR_SPOT_RATES

Line 1098: FROM xtr_spot_rates

1094: usd_base_curr_offer_rate ask_rate,
1095: 1/usd_base_curr_offer_rate bid_rate_base,
1096: 1/usd_base_curr_bid_rate ask_rate_base,
1097: currency
1098: FROM xtr_spot_rates
1099: WHERE (rate_date, currency) IN (SELECT MAX(rate_date), currency
1100: FROM xtr_spot_rates
1101: WHERE currency IN (p_in_rec.p_ccy, p_in_rec.p_contra_ccy)
1102: AND currency <> 'USD'

Line 1100: FROM xtr_spot_rates

1096: 1/usd_base_curr_bid_rate ask_rate_base,
1097: currency
1098: FROM xtr_spot_rates
1099: WHERE (rate_date, currency) IN (SELECT MAX(rate_date), currency
1100: FROM xtr_spot_rates
1101: WHERE currency IN (p_in_rec.p_ccy, p_in_rec.p_contra_ccy)
1102: AND currency <> 'USD'
1103: AND trunc(rate_date) <= trunc(p_in_rec.p_spot_date)
1104: GROUP BY currency);

Line 1286: --fetch the spot rate from xtr_spot_rates

1282: SELECT DECODE(fx_spot_side, 'BID/ASK', p_in_rec.p_side, fx_spot_side)
1283: INTO v_in_rec.p_side
1284: FROM xtr_rm_md_sets
1285: WHERE set_code = p_in_rec.p_md_set_code;
1286: --fetch the spot rate from xtr_spot_rates
1287: --check if cross rates
1288: v_count := 0;
1289: IF (p_in_rec.p_ccy <> 'USD' and p_in_rec.p_contra_ccy <> 'USD') THEN
1290: IF (p_in_rec.p_source = 'C') THEN

Line 1314: -- xtr_spot_rates table

1310: temprec.bid_rate_base, temprec.ask_rate_base,
1311: temprec.currency;
1312: ELSE
1313: -- bug 4145664 issue 12 if the hedgde is revalued for the first time rates to be picked from
1314: -- xtr_spot_rates table
1315: IF nvl(p_first_call,0) = 1 then
1316: FETCH get_fx_spot_rates INTO temprec.bid_rate, temprec.ask_rate,
1317: temprec.bid_rate_base, temprec.ask_rate_base,
1318: temprec.currency;