APPS.XTR_MARKET_DATA_P dependencies on XTR_RM_MD_SHOW_CURVES_V

Line 239: FROM xtr_rm_md_show_curves_v outter

235: bid_rate, 'A', offer_rate, 'ASK', offer_rate,
236: (bid_rate+offer_rate)/2),0) rate,
237: nvl(day_count_basis,'ACTUAL/ACTUAL') day_count_basis,
238: term_type, unique_period_id, currency
239: FROM xtr_rm_md_show_curves_v outter
240: WHERE curve_code = p_in_rec.p_curve_code
241: AND outter.rate_date=
242: (SELECT max(inner.rate_date)
243: FROM xtr_rm_md_show_curves_v inner

Line 243: FROM xtr_rm_md_show_curves_v inner

239: FROM xtr_rm_md_show_curves_v outter
240: WHERE curve_code = p_in_rec.p_curve_code
241: AND outter.rate_date=
242: (SELECT max(inner.rate_date)
243: FROM xtr_rm_md_show_curves_v inner
244: WHERE trunc(inner.rate_date) <= trunc(p_in_rec.p_spot_date)
245: AND curve_code = p_in_rec.p_curve_code
246: AND outter.unique_period_id=inner.unique_period_id)
247: ORDER BY 1;

Line 250: SELECT COUNT(*) FROM xtr_rm_md_show_curves_v t1,

246: AND outter.unique_period_id=inner.unique_period_id)
247: ORDER BY 1;
248:
249: CURSOR compare_dcb IS
250: SELECT COUNT(*) FROM xtr_rm_md_show_curves_v t1,
251: xtr_rm_md_show_curves_v t2
252: WHERE t1.curve_code = p_in_rec.p_curve_code
253: AND t2.curve_code = p_in_rec.p_curve_code
254: AND (t1.rate_date, t1.unique_period_id) IN

Line 251: xtr_rm_md_show_curves_v t2

247: ORDER BY 1;
248:
249: CURSOR compare_dcb IS
250: SELECT COUNT(*) FROM xtr_rm_md_show_curves_v t1,
251: xtr_rm_md_show_curves_v t2
252: WHERE t1.curve_code = p_in_rec.p_curve_code
253: AND t2.curve_code = p_in_rec.p_curve_code
254: AND (t1.rate_date, t1.unique_period_id) IN
255: (SELECT MAX(rate_date), unique_period_id

Line 256: FROM xtr_rm_md_show_curves_v

252: WHERE t1.curve_code = p_in_rec.p_curve_code
253: AND t2.curve_code = p_in_rec.p_curve_code
254: AND (t1.rate_date, t1.unique_period_id) IN
255: (SELECT MAX(rate_date), unique_period_id
256: FROM xtr_rm_md_show_curves_v
257: WHERE trunc(rate_date) <= trunc(p_in_rec.p_spot_date)
258: AND curve_code = p_in_rec.p_curve_code
259: GROUP BY unique_period_id)
260: AND (t2.rate_date, t2.unique_period_id) IN

Line 262: FROM xtr_rm_md_show_curves_v

258: AND curve_code = p_in_rec.p_curve_code
259: GROUP BY unique_period_id)
260: AND (t2.rate_date, t2.unique_period_id) IN
261: (SELECT MAX(rate_date), unique_period_id
262: FROM xtr_rm_md_show_curves_v
263: WHERE trunc(rate_date) <= trunc(p_in_rec.p_spot_date)
264: AND curve_code = p_in_rec.p_curve_code
265: GROUP BY unique_period_id)
266: AND nvl(t1.day_count_basis,'ACTUAL/ACTUAL')<>nvl(t2.day_count_basis,'ACTUAL/ACTUAL');