APPS.XTR_RATE_CHANGE dependencies on XTR_ROLLOVER_TRANSACTIONS_V

Line 50: from XTR_ROLLOVER_TRANSACTIONS_V t

46: and d.CURRENCY = nvl(p_currency, d.CURRENCY)
47: and d.PAYMENT_SCHEDULE_CODE = nvl(p_payment_schedule_code, d.PAYMENT_SCHEDULE_CODE)
48: and d.STATUS_CODE = 'CURRENT'
49: and exists( select 'ANY TRANS'
50: from XTR_ROLLOVER_TRANSACTIONS_V t
51: where nvl(t.STATUS_CODE, 'CURRENT') = 'CURRENT'
52: and t.BALANCE_OUT between nvl(p_min_balance, 0) and
53: nvl(p_max_balance, t.BALANCE_OUT + 1)
54: and t.SETTLE_DATE is NULL

Line 69: from XTR_ROLLOVER_TRANSACTIONS_V

65: and START_DATE = p_date;
66:
67: cursor T_NOS(p_deal_no NUMBER) is
68: select nvl(max(TRANSACTION_NUMBER),0) + 1
69: from XTR_ROLLOVER_TRANSACTIONS_V
70: where DEAL_NUMBER = p_deal_no;
71:
72: cursor THIS_ROW(p_deal_no NUMBER, p_date DATE) is
73: select PI_AMOUNT_DUE,

Line 77: from XTR_ROLLOVER_TRANSACTIONS_V

73: select PI_AMOUNT_DUE,
74: INTEREST_RATE,
75: PI_AMOUNT_RECEIVED,
76: MATURITY_DATE
77: from XTR_ROLLOVER_TRANSACTIONS_V
78: where DEAL_NUMBER = p_deal_no
79: and START_DATE < p_date
80: and MATURITY_DATE >= p_date
81: and nvl(PI_AMOUNT_DUE,0) <> 0

Line 143: update XTR_ROLLOVER_TRANSACTIONS_V

139: else
140: l_new_pi_amount_due := null;
141: end if;
142:
143: update XTR_ROLLOVER_TRANSACTIONS_V
144: set INTEREST_RATE = p_new_interest_rate,
145: RATE_EFFECTIVE_CREATED = l_created_on, -- AW 7/15 sysdate,
146: PI_AMOUNT_DUE = nvl(l_new_pi_amount_due, PI_AMOUNT_DUE)
147: where DEAL_NUMBER = deal.DEAL_NO

Line 180: insert into XTR_ROLLOVER_TRANSACTIONS_V

176: l_maturity_date;
177: close THIS_ROW;
178:
179: if l_tran_num is NOT NULL then
180: insert into XTR_ROLLOVER_TRANSACTIONS_V
181: (DEAL_NUMBER,
182: TRANSACTION_NUMBER,
183: DEAL_TYPE,
184: RATE_FIXING_DATE,

Line 324: from XTR_ROLLOVER_TRANSACTIONS_V

320: select START_DATE, MATURITY_DATE,
321: EXPECTED_BALANCE_BF,EXPECTED_BALANCE_OUT,
322: PRINCIPAL_ADJUST,
323: INTEREST_RATE
324: from XTR_ROLLOVER_TRANSACTIONS_V
325: where DEAL_NUMBER = p_deal_number
326: and STATUS_CODE = 'CURRENT'
327: and MATURITY_DATE >= p_effective_from_date
328: and START_DATE < p_effective_from_date

Line 333: from XTR_ROLLOVER_TRANSACTIONS_V

329: order by START_DATE asc,TRANSACTION_NUMBER asc;
330:
331: cursor START_ROW is
332: select START_DATE,EXPECTED_BALANCE_BF, PRINCIPAL_ADJUST
333: from XTR_ROLLOVER_TRANSACTIONS_V
334: where DEAL_NUMBER = p_deal_number
335: and STATUS_CODE = 'CURRENT'
336: and START_DATE >= p_effective_from_date
337: order by START_DATE asc,TRANSACTION_NUMBER asc;