APPS.XTR_RESET_BOND_RATE dependencies on XTR_DEALS

Line 18: l_company XTR_DEALS.COMPANY_CODE%TYPE;

14: p_overwrite_type IN VARCHAR2 DEFAULT 'N')
15: AS
16: l_buf VARCHAR2(300);
17: l_rowid ROWID;
18: l_company XTR_DEALS.COMPANY_CODE%TYPE;
19: l_deal_no NUMBER;
20: l_tran_no NUMBER;
21: l_deal_type XTR_DEALS.DEAL_TYPE%TYPE;
22: l_start_date DATE;

Line 21: l_deal_type XTR_DEALS.DEAL_TYPE%TYPE;

17: l_rowid ROWID;
18: l_company XTR_DEALS.COMPANY_CODE%TYPE;
19: l_deal_no NUMBER;
20: l_tran_no NUMBER;
21: l_deal_type XTR_DEALS.DEAL_TYPE%TYPE;
22: l_start_date DATE;
23: l_coupon_date DATE;
24: l_ratefix_date DATE;
25: l_bond_issue_code XTR_BOND_COUPON_DATES.bond_issue_code%TYPE;

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 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

Line 517: FROM XTR_DEALS

513: l_buf1 VARCHAR2(300);
514: -- Start Fix not to show transactions with zero amount
515: CURSOR C_GET_BALANCE_AMOUNT (p_deal NUMBER) IS
516: SELECT maturity_balance_amount
517: FROM XTR_DEALS
518: WHERE DEAL_NO = p_deal;
519:
520: l_balance_amount NUMBER;
521: