APPS.XTR_MM_COVERS dependencies on XTR_DEALS

Line 2380: p_day_count_type xtr_deals.day_count_type%TYPE;

2376: PROCEDURE calc_bond_coupon_amt(p_in_rec IN CalcBondCpnAmt_in_rec,
2377: p_out_rec IN OUT NOCOPY CalcBondCpnAmt_out_rec) IS
2378:
2379: p_maturity_amount NUMBER;
2380: p_day_count_type xtr_deals.day_count_type%TYPE;
2381: p_settlement_date DATE;
2382: p_rounding_type xtr_deals.rounding_type%TYPE;
2383: p_deal_date DATE;
2384: p_income_tax_ref NUMBER;

Line 2382: p_rounding_type xtr_deals.rounding_type%TYPE;

2378:
2379: p_maturity_amount NUMBER;
2380: p_day_count_type xtr_deals.day_count_type%TYPE;
2381: p_settlement_date DATE;
2382: p_rounding_type xtr_deals.rounding_type%TYPE;
2383: p_deal_date DATE;
2384: p_income_tax_ref NUMBER;
2385: p_income_tax_rate NUMBER;
2386: p_coupon_tax_code xtr_rollover_transactions.tax_code%TYPE;

Line 2387: p_bond_issue_code xtr_deals.bond_issue%TYPE;

2383: p_deal_date DATE;
2384: p_income_tax_ref NUMBER;
2385: p_income_tax_rate NUMBER;
2386: p_coupon_tax_code xtr_rollover_transactions.tax_code%TYPE;
2387: p_bond_issue_code xtr_deals.bond_issue%TYPE;
2388: l_last_coupon_date date;
2389: l_coupon_date date;
2390: l_bond_start_date date;
2391: l_bond_maturity_date date;

Line 2439: from xtr_deals d, xtr_rollover_transactions rt

2435: select d.start_date,d.maturity_balance_amount,d.day_count_type,
2436: d.rounding_type,
2437: d.deal_date,rt.tax_settled_reference,rt.tax_rate,d.bond_issue,
2438: rt.tax_code,rt.maturity_date
2439: from xtr_deals d, xtr_rollover_transactions rt
2440: where d.deal_no=p_deal_no
2441: and rt.deal_number=d.deal_no
2442: and rt.transaction_number=p_trans_no;
2443: --

Line 2628: from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt

2624:
2625: cursor check_coupon_rate_reset(p_deal_no NUMBER,
2626: p_trans_no NUMBER) is
2627: select count(*)
2628: from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt
2629: where rt.deal_number=p_deal_no
2630: and rt.transaction_number=p_trans_no
2631: and d.deal_no=rt.deal_number
2632: and bc.bond_issue_code=d.bond_issue

Line 2638: from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt

2634: and bc.rate_update_on 2635:
2636: cursor check_coupon_rate_reset_all(p_deal_no NUMBER) is
2637: select count(*)
2638: from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt
2639: where d.deal_no=p_deal_no
2640: and d.deal_no=rt.deal_number
2641: and bc.bond_issue_code=d.bond_issue
2642: and bc.coupon_date=rt.maturity_date