APPS.XTR_RESET_BOND_RATE dependencies on XTR_ROLLOVER_TRANSACTIONS

Line 226: from xtr_deals d, xtr_rollover_transactions rt

222:
223: cursor check_overridden_cpn_amt(p_bond_issue_code VARCHAR2,
224: p_coupon_date DATE) is
225: select count(*)
226: from xtr_deals d, xtr_rollover_transactions rt
227: where d.deal_no=rt.deal_number
228: and d.bond_issue=p_bond_issue_code
229: and rt.maturity_date=p_coupon_date
230: and rt.interest<>rt.original_amount

Line 333: FROM XTR_ROLLOVER_TRANSACTIONS

329: p_update_type IN VARCHAR2) AS
330:
331: CURSOR C_GET_SEQ_TRANSACTIONS IS
332: SELECT maturity_date,transaction_number
333: FROM XTR_ROLLOVER_TRANSACTIONS
334: WHERE deal_number = p_deal_number
335: AND transaction_number >= p_transaction_number
336: ORDER BY transaction_number;
337:

Line 346: UPDATE XTR_ROLLOVER_TRANSACTIONS

342:
343:
344: BEGIN
345: IF p_update_type = 'SINGLE' THEN
346: UPDATE XTR_ROLLOVER_TRANSACTIONS
347: SET INTEREST_RATE=P_NEW_RATE,
348: UPDATED_ON = SYSDATE,
349: UPDATED_BY = fnd_global.user_id
350: WHERE STATUS_CODE = 'CURRENT'

Line 363: UPDATE XTR_ROLLOVER_TRANSACTIONS

359: LOOP
360: FETCH C_GET_SEQ_TRANSACTIONS into l_coupon_date,l_trans_no;
361: EXIT when C_GET_SEQ_TRANSACTIONS%notfound;
362:
363: UPDATE XTR_ROLLOVER_TRANSACTIONS
364: SET INTEREST_RATE=P_NEW_RATE,
365: UPDATED_ON = SYSDATE,
366: UPDATED_BY = fnd_global.user_id
367: WHERE STATUS_CODE = 'CURRENT'

Line 399: from xtr_rollover_transactions rt

395: CURSOR C_GET_CURR_RELATED_TRANS(p_deal_number NUMBER,
396: p_transaction_number NUMBER) is
397: select rt.deal_number,rt.transaction_number,rt.tax_settled_reference,
398: rt.currency,rt.deal_subtype,rt.tax_code,rt.tax_amount
399: from xtr_rollover_transactions rt
400: where rt.status_code='CURRENT'
401: and rt.deal_number = p_deal_number
402: and rt.transaction_number = p_transaction_number
403: and rt.deal_subtype in ('ISSUE','SHORT','BUY')

Line 443: --update XTR_ROLLOVER_TRANSACTIONS

439: curr_trans_info.tax_code,
440: v_income_ctype,
441: v_income_method);
442: end if;
443: --update XTR_ROLLOVER_TRANSACTIONS
444: UPDATE xtr_rollover_transactions
445: set interest=v_new_cpn_amt,interest_hce=v_hce_amt,
446: tax_amount=v_tax_amt,original_amount=v_new_cpn_amt,
447: UPDATED_ON = sysdate,

Line 444: UPDATE xtr_rollover_transactions

440: v_income_ctype,
441: v_income_method);
442: end if;
443: --update XTR_ROLLOVER_TRANSACTIONS
444: UPDATE xtr_rollover_transactions
445: set interest=v_new_cpn_amt,interest_hce=v_hce_amt,
446: tax_amount=v_tax_amt,original_amount=v_new_cpn_amt,
447: UPDATED_ON = sysdate,
448: UPDATED_BY = fnd_global.user_id

Line 504: from xtr_rollover_transactions rt, xtr_deals d

500:
501: CURSOR C_GET_RELATED_TRANS(p_bond_issue_code VARCHAR2,
502: p_coupon_date DATE) is
503: select rt.deal_number,rt.transaction_number
504: from xtr_rollover_transactions rt, xtr_deals d
505: where rt.status_code='CURRENT'
506: and d.deal_no=rt.deal_number
507: and rt.deal_subtype in ('ISSUE','SHORT','BUY')
508: and d.bond_issue=p_bond_issue_code