APPS.XTR_MARKET_DATA_P dependencies on XTR_REVALUATION_RATES

Line 282: FROM xtr_revaluation_rates r, xtr_rm_md_curve_rates c

278: (nvl(r.bid,r.bid_overwrite)+nvl(r.ask,r.ask_overwrite))/2),0) rate,
279: nvl(r.day_count_basis,'ACTUAL/ACTUAL') day_count_basis,
280: r.day_mth term_type, r.reval_type unique_period_id,
281: r.currencyA currency, r.volatility_or_rate rate_type
282: FROM xtr_revaluation_rates r, xtr_rm_md_curve_rates c
283: WHERE r.reval_type = c.rate_code
284: AND c.curve_code = p_in_rec.p_curve_code
285: AND r.batch_id = p_in_rec.p_batch_id
286: ORDER BY 1;

Line 289: SELECT COUNT(*) FROM xtr_revaluation_rates r1,xtr_revaluation_rates r2,

285: AND r.batch_id = p_in_rec.p_batch_id
286: ORDER BY 1;
287:
288: CURSOR compare_dcb_reval IS
289: SELECT COUNT(*) FROM xtr_revaluation_rates r1,xtr_revaluation_rates r2,
290: xtr_rm_md_curve_rates c1, xtr_rm_md_curve_rates c2
291: WHERE r1.reval_type = c1.rate_code
292: AND r2.reval_type = c2.rate_code
293: AND c1.curve_code = p_in_rec.p_curve_code

Line 1119: FROM xtr_revaluation_rates

1115: DECODE(currencyA, 'USD', 1/nvl(bid_overwrite,bid),
1116: nvl(ask_overwrite,ask)) ask_rate_base,
1117: DECODE(currencyA, 'USD', currencyB, currencyA) currency
1118: --gives non-USD currency
1119: FROM xtr_revaluation_rates
1120: WHERE ((currencyA = 'USD' and currencyB
1121: IN (p_in_rec.p_ccy,p_in_rec.p_contra_ccy))
1122: or (currencyB = 'USD' and currencyA
1123: IN (p_in_rec.p_ccy,p_in_rec.p_contra_ccy)))

Line 1467: FROM xtr_revaluation_rates

1463: 'ASK', nvl(ask_overwrite,ask),
1464: 'B', nvl(bid_overwrite,bid),
1465: (nvl(ask_overwrite,ask)+nvl(bid_overwrite,bid))/2)
1466: INTO p_out_rec.p_md_out
1467: FROM xtr_revaluation_rates
1468: WHERE reval_type = p_in_rec.p_bond_code
1469: AND volatility_or_rate = 'PRIC'
1470: AND day_mth IS NULL
1471: AND batch_id = p_in_rec.p_batch_id;

Line 1517: FROM xtr_revaluation_rates

1513: 'ASK', nvl(ask_overwrite,ask),
1514: 'B', nvl(bid_overwrite,bid),
1515: (nvl(ask_overwrite,ask)+nvl(bid_overwrite,bid))/2)
1516: INTO p_out_rec.p_md_out
1517: FROM xtr_revaluation_rates
1518: WHERE reval_type = p_in_rec.p_bond_code
1519: AND volatility_or_rate = 'PRIC'
1520: AND day_mth IS NULL
1521: AND batch_id = p_in_rec.p_batch_id;