APPS.XTR_MARKET_DATA_P dependencies on XTR_RM_MD_SETS

Line 1284: FROM xtr_rm_md_sets

1280: --for FX spot rate
1281: --check p_side
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;

Line 1457: FROM xtr_rm_md_sets

1453: --for bond price
1454: --check p_side
1455: SELECT DECODE(bond_price_side, 'BID/ASK', p_in_rec.p_side, bond_price_side)
1456: INTO v_in_rec.p_side
1457: FROM xtr_rm_md_sets
1458: WHERE set_code = p_in_rec.p_md_set_code;
1459:
1460: IF (p_in_rec.p_source = 'R') THEN
1461: SELECT DECODE(v_in_rec.p_side, 'BID', nvl(bid_overwrite,bid),

Line 1507: FROM xtr_rm_md_sets

1503: --for stock price
1504: --check p_side
1505: SELECT DECODE(stock_price_side, 'BID/ASK', p_in_rec.p_side, stock_price_side)
1506: INTO v_in_rec.p_side
1507: FROM xtr_rm_md_sets
1508: WHERE set_code = p_in_rec.p_md_set_code;
1509:
1510: IF (p_in_rec.p_source = 'R') THEN
1511: SELECT DECODE(v_in_rec.p_side, 'BID', nvl(bid_overwrite,bid),