APPS.XTR_MM_COVERS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 1375

 select YEAR_CALC_TYPE,COUPON_RATE,CURRENCY,CALC_TYPE,
        COMMENCE_DATE,nvl(NO_OF_COUPONS_PER_YEAR,0),
        nvl(ACCRUED_INT_YEAR_CALC_BASIS,YEAR_CALC_TYPE),MATURITY_DATE,
        price_rounding,price_round_type,yield_rounding,yield_round_type,
        calc_rounding, rounding_type
  from XTR_BOND_ISSUES_V
  where BOND_ISSUE_CODE = p_bond_issue_code;

Line: 1384

 select max(COUPON_DATE),                        --------------------------------------------------------
        min(COUPON_DATE), greatest(count(*)-1,0) -- COMPOUND COUPON: first coupon date, prev full coupon
  from  XTR_BOND_COUPON_DATES                    --------------------------------------------------------
  where BOND_ISSUE_CODE = p_bond_issue_code
  and   COUPON_DATE    <= p_settlement_date;

Line: 1391

 select min(COUPON_DATE),nvl(count(COUPON_DATE),0)
  from XTR_BOND_COUPON_DATES
  where BOND_ISSUE_CODE = p_bond_issue_code
  and COUPON_DATE > p_settlement_date;

Line: 1398

select count(*)-1
from   xtr_bond_coupon_dates
where  bond_issue_code = p_issue_code;

Line: 1404

select c.rate, i.float_margin
  from xtr_bond_coupon_dates c, xtr_bond_issues i
  where c.bond_issue_code=p_bond_issue_code
  and c.bond_issue_code=i.bond_issue_code
  and c.coupon_date=(select min(COUPON_DATE)
  	from XTR_BOND_COUPON_DATES
  	where BOND_ISSUE_CODE = p_bond_issue_code
  	and COUPON_DATE > p_settlement_date);

Line: 1523

        select min(COUPON_DATE)
        into   l_odd_coupon_maturity
        from   xtr_bond_coupon_dates
        where  bond_issue_code = p_bond_issue_code;

Line: 2415

	select i.currency,
	       c.rate,
	       i.no_of_coupons_per_year,
	       i.maturity_date,
	       i.year_calc_type,
	       i.commence_date,
	       i.calc_type
	from xtr_bond_issues i, xtr_bond_coupon_dates c
	where i.bond_issue_code = p_bond_issue_code
        and c.bond_issue_code=i.bond_issue_code
        and c.coupon_date=p_coupon_date;

Line: 2429

	select max(coupon_date)
	from xtr_bond_coupon_dates
	where bond_issue_code = p_bond_issue_code
	and coupon_date < p_next_coupon_date;

Line: 2435

        select d.start_date,d.maturity_balance_amount,d.day_count_type,
        d.rounding_type,
	d.deal_date,rt.tax_settled_reference,rt.tax_rate,d.bond_issue,
	rt.tax_code,rt.maturity_date
        from xtr_deals d, xtr_rollover_transactions rt
        where d.deal_no=p_deal_no
        and rt.deal_number=d.deal_no
        and rt.transaction_number=p_trans_no;

Line: 2445

	select TAX_SETTLE_METHOD
  	from   XTR_TAX_BROKERAGE_SETUP
  	where  REFERENCE_CODE = p_tax_code;

Line: 2454

   Select sum(face_value)
     from xtr_bond_alloc_details
    where deal_no = p_deal_no
      and cross_ref_start_date >= l_curr_cpn_date;

Line: 2627

      select count(*)
      from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt
      where rt.deal_number=p_deal_no
      and rt.transaction_number=p_trans_no
      and d.deal_no=rt.deal_number
      and bc.bond_issue_code=d.bond_issue
      and bc.coupon_date=rt.maturity_date
      and bc.rate_update_on

      select count(*)
      from xtr_bond_coupon_dates bc, xtr_deals d, xtr_rollover_transactions rt
      where d.deal_no=p_deal_no
      and d.deal_no=rt.deal_number
      and bc.bond_issue_code=d.bond_issue
      and bc.coupon_date=rt.maturity_date
      and bc.rate_update_on

      select deal_number,transaction_number
      from xtr_rollover_transactions
      where tax_settled_reference=p_settled_ref;