APPS.XTR_MARKET_DATA_P dependencies on XTR_INTEREST_PERIOD_RATES

Line 1473: --fetch bond price from xtr_interest_period_rates

1469: AND volatility_or_rate = 'PRIC'
1470: AND day_mth IS NULL
1471: AND batch_id = p_in_rec.p_batch_id;
1472: ELSE
1473: --fetch bond price from xtr_interest_period_rates
1474: SELECT DECODE(v_in_rec.p_side,
1475: 'ASK', offer_rate,
1476: 'A', offer_rate,
1477: 'BID', bid_rate,

Line 1481: FROM xtr_interest_period_rates

1477: 'BID', bid_rate,
1478: 'B', bid_rate,
1479: (bid_rate+offer_rate)/2)
1480: INTO p_out_rec.p_md_out
1481: FROM xtr_interest_period_rates
1482: WHERE (rate_date, unique_period_id) IN
1483: (SELECT MAX(rate_date), unique_period_id
1484: FROM xtr_interest_period_rates
1485: WHERE trunc(rate_date) <= trunc(p_in_rec.p_spot_date)

Line 1484: FROM xtr_interest_period_rates

1480: INTO p_out_rec.p_md_out
1481: FROM xtr_interest_period_rates
1482: WHERE (rate_date, unique_period_id) IN
1483: (SELECT MAX(rate_date), unique_period_id
1484: FROM xtr_interest_period_rates
1485: WHERE trunc(rate_date) <= trunc(p_in_rec.p_spot_date)
1486: AND unique_period_id = p_in_rec.p_bond_code
1487: GROUP BY unique_period_id)
1488: AND term_type = 'B';

Line 1523: --fetch stock price from xtr_interest_period_rates

1519: AND volatility_or_rate = 'PRIC'
1520: AND day_mth IS NULL
1521: AND batch_id = p_in_rec.p_batch_id;
1522: ELSE
1523: --fetch stock price from xtr_interest_period_rates
1524: SELECT DECODE(v_in_rec.p_side,
1525: 'ASK', offer_rate,
1526: 'A', offer_rate,
1527: 'BID', bid_rate,

Line 1531: FROM xtr_interest_period_rates

1527: 'BID', bid_rate,
1528: 'B', bid_rate,
1529: (bid_rate+offer_rate)/2)
1530: INTO p_out_rec.p_md_out
1531: FROM xtr_interest_period_rates
1532: WHERE (rate_date, unique_period_id) IN
1533: (SELECT MAX(rate_date), unique_period_id
1534: FROM xtr_interest_period_rates
1535: WHERE trunc(rate_date) <= trunc(p_in_rec.p_spot_date)

Line 1534: FROM xtr_interest_period_rates

1530: INTO p_out_rec.p_md_out
1531: FROM xtr_interest_period_rates
1532: WHERE (rate_date, unique_period_id) IN
1533: (SELECT MAX(rate_date), unique_period_id
1534: FROM xtr_interest_period_rates
1535: WHERE trunc(rate_date) <= trunc(p_in_rec.p_spot_date)
1536: AND unique_period_id = p_in_rec.p_bond_code
1537: GROUP BY unique_period_id)
1538: AND term_type = 'T';