eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QRM_PA_CALCULATION_P dependencies on XTR_DEALS_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 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'