APPS.QRM_PA_CALCULATION_P dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 222: Cursors that access xtr_rollover_transactions_v, xtr_deals_v

218: FROM xtr_bond_coupon_dates
219: WHERE coupon_date <= p_ref_date AND bond_issue_code = p_bond_issue_code;
220:
221: /*---------------------------------------------------------------------
222: Cursors that access xtr_rollover_transactions_v, xtr_deals_v
223: access valid deals because those deals numbers are first derived
224: from qrm_current_deals_v.
225: ----------------------------------------------------------------------*/
226:

Line 231: FROM xtr_rollover_transactions_v

227: -- gets current transaction
228: CURSOR get_tmm_irs_rtmm_curr_trans(p_deal_no NUMBER,
229: p_deal_type VARCHAR2, p_ref_date DATE) IS
230: SELECT *
231: FROM xtr_rollover_transactions_v
232: WHERE deal_number=p_deal_no AND deal_type=p_deal_type AND
233: start_date<=p_ref_date AND p_ref_date 234: status_code<>'CANCELLED' AND status_code<>'CLOSED'
235: ORDER BY start_date, maturity_date;

Line 240: FROM xtr_rollover_transactions_v

236:
237: -- for all current/future transactions of TMM/IRS/RTMM
238: CURSOR get_tmm_irs_rtmm_trans(p_deal_no NUMBER, p_ref_date DATE) IS
239: SELECT *
240: FROM xtr_rollover_transactions_v
241: WHERE deal_number=p_deal_no
242: AND ((p_ref_date 243: (p_ref_date>=start_date AND p_ref_date 244: status_code<>'CANCELLED' AND status_code<>'CLOSED'

Line 257: FROM xtr_rollover_transactions_v rt, xtr_deals_v d

253:
254: -- all current and future cashflows
255: CURSOR get_bond_cashflows(p_deal_no NUMBER, p_ref_date DATE) IS
256: SELECT rt.interest, d.interest_rate, rt.start_date, rt.maturity_date
257: FROM xtr_rollover_transactions_v rt, xtr_deals_v d
258: WHERE rt.deal_number=d.deal_no AND rt.deal_number=p_deal_no AND
259: ((p_ref_date<=rt.start_date) OR (p_ref_date>=rt.start_date AND
260: p_ref_date 261: rt.status_code<>'CANCELLED' AND rt.status_code<>'CLOSED'

Line 267: FROM xtr_rollover_transactions_v

263: ORDER BY rt.maturity_date; --bug 2804548
264:
265: /* CURSOR get_last_trans_no(p_deal_no NUMBER) IS
266: SELECT max(transaction_number)
267: FROM xtr_rollover_transactions_v
268: GROUP BY deal_number
269: HAVING deal_number=p_deal_no; Bug 4965436 */
270:
271: CURSOR get_last_trans_no(p_deal_no NUMBER) IS

Line 273: FROM xtr_rollover_transactions_v

269: HAVING deal_number=p_deal_no; Bug 4965436 */
270:
271: CURSOR get_last_trans_no(p_deal_no NUMBER) IS
272: SELECT max(transaction_number)
273: FROM xtr_rollover_transactions_v
274: WHERE deal_number=p_deal_no;
275:
276: e_duplicate_tb_rows EXCEPTION; --bug 2875633
277:

Line 6910: FROM xtr_rollover_transactions_v

6906: RETURN DATE IS
6907:
6908: CURSOR get_transaction_data IS
6909: SELECT rate_fixing_date, start_date, maturity_date
6910: FROM xtr_rollover_transactions_v
6911: WHERE deal_number=p_deal_no;
6912:
6913: /* CURSOR get_deal_data IS
6914: SELECT max(maturity_date), settle_date

Line 6933: FROM xtr_rollover_transactions_v

6929: -- the second part is when the ref_date > fixed until date, so the
6930: -- next gap date is the next start date after ref date
6931: CURSOR get_others (p_date DATE) IS
6932: SELECT DISTINCT maturity_date
6933: FROM xtr_rollover_transactions_v
6934: WHERE deal_number=p_deal_no
6935: AND ( (p_ref_date<=p_date
6936: and start_date 6937: and p_date<=maturity_date