APPS.XTR_MARKET_DATA_P dependencies on XTR_RM_MD_CURVE_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 290: xtr_rm_md_curve_rates c1, xtr_rm_md_curve_rates c2

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
294: AND c2.curve_code = p_in_rec.p_curve_code