APPS.XTR_CALCULATION_P SQL Statements

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

Line: 324

  select to_number(POST_MONTHS_FORWARD),INTEREST_ACTION,
        JAN_YN,FEB_YN,MAR_YN,APR_YN,MAY_YN,JUN_YN,JUL_YN,AUG_YN,
        SEP_YN,OCT_YN,NOV_YN,DEC_YN,PAYMENT_SCHEDULE_CODE,
	PAYMENT_FREQUENCY,MIN_POSTINGS,POSTING_FREQ,
        NEXT_POSTING_DUE
  from  XTR_PAYMENT_SCHEDULE
  where PAYMENT_SCHEDULE_CODE = P_PAYMENT_SCHEDULE_CODE
  and DEAL_TYPE = 'RTMM'
  and DEAL_SUBTYPE = P_DEAL_SUBTYPE
  and PRODUCT_TYPE = P_PRODUCT_TYPE
  and nvl(NEXT_POSTING_DUE, l_start_date) <= l_start_date;

Line: 343

  select a.DEAL_NO,a.DEAL_DATE,a.START_DATE,a.MATURITY_DATE,
	a.CPARTY_CODE,a.CLIENT_CODE,a.PRODUCT_TYPE,
        a.PORTFOLIO_CODE,a.MATURITY_ACCOUNT_NO,a.CPARTY_REF,
        a.COMPANY_CODE,a.DEALER_CODE,a.TERM_MY,a.CURRENCY,
        a.FACE_VALUE_AMOUNT,a.PAYMENT_FREQ,a.SETTLE_DATE,SETTLE_ACCOUNT_NO,
        a.LIMIT_CODE,a.PAYMENT_SCHEDULE_CODE ,a.DEAL_TYPE,a.DEAL_SUBTYPE,
	--31441263
        a.rounding_type,a.year_calc_type,a.day_count_type
  from XTR_DEALS_V a
  where  a.deal_type = 'RTMM'
  and a.maturity_date > l_start_date
  and a.PAYMENT_SCHEDULE_CODE = L_PAYMENT_SCHEDULE_CODE
  and a.status_code = 'CURRENT'
  and a.deal_subtype = P_DEAL_SUBTYPE
  and a.product_type = P_PRODUCT_TYPE
  and a.maturity_date > (select max(b.maturity_date)
                           from XTR_ROLLOVER_TRANSACTIONS_V b
                           where b.deal_number = a.deal_no);

Line: 365

  select start_date,maturity_date,expected_balance_out,balance_out,
        accum_interest,interest_rate,pi_amount_due
  from XTR_ROLLOVER_TRANSACTIONS_V
  where deal_number = l_deal_no
  -- and maturity_date >= l_start_date
  order by start_date desc,maturity_date desc,transaction_number desc;

Line: 375

  select ROUNDING_FACTOR,YEAR_BASIS,nvl(HCE_RATE,1) HCE_RATE
  from XTR_MASTER_CURRENCIES_V
  where CURRENCY = p_ccy;

Line: 382

  select nvl(max(TRANSACTION_NUMBER), 0) + 1
  from XTR_ROLLOVER_TRANSACTIONS_V
  where DEAL_NUMBER = l_deal_no;

Line: 561

   	  insert into XTR_ROLLOVER_TRANSACTIONS
               (DEAL_NUMBER,
		TRANSACTION_NUMBER,
		DEAL_TYPE,
		START_DATE,
		MATURITY_DATE,
         	INTEREST_RATE,
		NO_OF_DAYS,
		PI_AMOUNT_DUE,
		BALANCE_OUT_BF,
		BALANCE_OUT_BF_HCE,
         	BALANCE_OUT,
		BALANCE_OUT_HCE,
		ACCUM_INTEREST_BF,
		ACCUM_INTEREST_BF_HCE,
         	INTEREST,
		INTEREST_HCE,
		EXPECTED_BALANCE_BF,
		EXPECTED_BALANCE_OUT,
         	CREATED_BY,
		CREATED_ON,
		PRINCIPAL_ADJUST,
		STATUS_CODE,
		COMPANY_CODE,
		BAL_OS_ACCOUNT_NO,
		CURRENCY,
		CLIENT_CODE,
		DEAL_SUBTYPE,
		PRODUCT_TYPE,
		CPARTY_CODE,
		DEAL_DATE,
		PORTFOLIO_CODE,
		LIMIT_CODE,
		INTEREST_SETTLED,
		PRINCIPAL_ACTION,
                --bug 3141263
		ACCUM_INT_AMOUNT_TYPE,
		ACCUM_INTEREST,
		ACCUM_INTEREST_HCE,
		ADJUSTED_BALANCE,
		PRINCIPAL_ADJUST_HCE,
		PRINCIPAL_AMOUNT_TYPE,
		RATE_FIXING_DATE)
  	  values(c_deal.DEAL_NO,
		TRANS_NO,
		'RTMM',
		l_start,
        	F_MATURITY_DATE,
		F_INTEREST_RATE,
		v_no_of_days, --bug 3141263 F_MATURITY_DATE - F_START_DATE,
		F_PI_AMOUNT_DUE,
		F_BALANCE_OUT_BF,
		F_BALANCE_OUT_BF_HCE,
        	F_BALANCE_OUT,
		F_BALANCE_OUT_HCE,
		F_ACCUM_INTEREST_BF,
		F_ACCUM_INTEREST_BF_HCE,
        	F_INTEREST,
		F_INTEREST_HCE,
		F_EXPECTED_BALANCE_BF,
		F_EXPECTED_BALANCE_OUT,
		fnd_global.user_id,
        	l_start_date,
		v_principal_adjust,
		'CURRENT',
		c_deal.COMPANY_CODE,
		c_deal.SETTLE_ACCOUNT_NO,
		c_deal.CURRENCY,
		c_deal.CLIENT_CODE,
		c_deal.DEAL_SUBTYPE,
		c_deal.PRODUCT_TYPE,
		c_deal.CPARTY_CODE,
		c_deal.DEAL_DATE,
		c_deal.PORTFOLIO_CODE,
		c_deal.LIMIT_CODE,
		0,
		v_principal_action, --bug 3141263 'INCRSE');

Line: 685

    UPDATE xtr_payment_schedule
    SET next_posting_due	= add_months(l_start_date,nvl(L_POSTING_FREQ,1))
    WHERE deal_type = 'RTMM'
    AND deal_subtype = P_DEAL_SUBTYPE
    AND product_type = P_PRODUCT_TYPE
    AND payment_schedule_code = P_PAYMENT_SCHEDULE_CODE;

Line: 714

  select DEAL_SUBTYPE, PRODUCT_TYPE,PAYMENT_SCHEDULE_CODE
  from   XTR_PAYMENT_SCHEDULE
  where  PAYMENT_SCHEDULE_CODE = nvl(P_PAYMENT_SCHEDULE_CODE,PAYMENT_SCHEDULE_CODE)
  and    DEAL_TYPE = 'RTMM'
  and    DEAL_SUBTYPE = nvl(P_DEAL_SUBTYPE,DEAL_SUBTYPE)
  and    PRODUCT_TYPE = nvl(P_PRODUCT_TYPE,PRODUCT_TYPE)
  order by  DEAL_SUBTYPE, PRODUCT_TYPE,PAYMENT_SCHEDULE_CODE;