APPS.XTR_FPS1_P SQL Statements

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

Line: 15

	select nvl(a.CPARTY_ADVICE,'Y'),nvl(a.CLIENT_ADVICE,'Y')
	 from XTR_PRODUCT_TYPES a
	 where a.DEAL_TYPE = l_deal_type
	 and   a.PRODUCT_TYPE = l_product;

Line: 21

	select a.CLIENT_ADVICE
	 from XTR_PARTY_INFO_V a
	 where a.PARTY_CODE = l_cparty;

Line: 26

	select a.CLIENT_ADVICE
	 from XTR_PARTY_INFO_V a
	 where a.PARTY_CODE = l_client;

Line: 161

  select m.YEAR_BASIS
   from  XTR_MASTER_CURRENCIES m
   where CURRENCY = l_counter_ccy;

Line: 166

  select c.LAN, d.LAN, e.LAN
   from  XTR_CUM_DIST_CALCS c,
	 XTR_CUM_DIST_CALCS d,
	 XTR_CUM_DIST_CALCS e
   where c.MKT_EXP = round(fp/ep,2)
   and   d.MKT_EXP = (round((FP/EP),2) + .005)
   and   e.MKT_EXP = (round((FP/EP),2) - .005);

Line: 175

  select c.EXPT,d.EXPT,e.EXPT
   from  XTR_CUM_DIST_CALCS c,
	 XTR_CUM_DIST_CALCS d,
	 XTR_CUM_DIST_CALCS e
   where c.INT_DAYS = round((-(1)*r*t),2)
   and   d.INT_DAYS = (round((-(1)*r*t),2) + .005)
   and   e.INT_DAYS = (round((-(1)*r*t),2) - .005);

Line: 184

  select c.PROBABILITY, d.PROBABILITY, e.PROBABILITY
   from  XTR_CUM_DIST_CALCS c,
	 XTR_CUM_DIST_CALCS d,
	 XTR_CUM_DIST_CALCS e
   where c.DEVIATION = round(d1,2)
   and   d.DEVIATION = (round(d1,2) + .005)
   and   e.DEVIATION = (round(d1,2) - .005);

Line: 193

  select c.PROBABILITY, d.PROBABILITY, e.PROBABILITY
   from  XTR_CUM_DIST_CALCS c,
	 XTR_CUM_DIST_CALCS d,
	 XTR_CUM_DIST_CALCS e
   where c.DEVIATION = round(d2,2)
   and   d.DEVIATION = (round(d2,2) + .005)
   and   e.DEVIATION = (round(d2,2) - .005);

Line: 338

  select nvl(rounding_factor,2)
   from  XTR_MASTER_CURRENCIES_V s
   where s.CURRENCY   = l_ccy;

Line: 343

  select b.CALC_BASIS,
         nvl(d.INTEREST_RATE,0)
   from  XTR_TAX_BROKERAGE_SETUP a,
	 XTR_DEDUCTION_CALCS b,
         XTR_TAX_BROKERAGE_RATES d
   where a.REFERENCE_CODE      = l_bkge_ref
   and   nvl(a.AUTHORISED,'N') = 'Y'
   and   b.DEAL_TYPE           = l_deal_type
   and   b.CALC_TYPE           = a.CALC_TYPE
   and   b.AMOUNT_TYPE         = l_bkr_amt_type
   and   d.RATE_GROUP          = a.RATE_GROUP
   and   d.REF_TYPE            = 'B'
   and   d.EFFECTIVE_FROM     <= l_deal_date
   and   nvl(d.MIN_AMT,0)     <= l_bkr_amt
   and   (d.MAX_AMT >= l_bkr_amt or d.MAX_AMT is NULL)
   order by d.EFFECTIVE_FROM desc;

Line: 361

  select b.CALC_BASIS,
         nvl(d.INTEREST_RATE,0)
   from  XTR_TAX_BROKERAGE_SETUP a,
	 XTR_DEDUCTION_CALCS b,
         XTR_TAX_BROKERAGE_RATES d
   where a.REFERENCE_CODE      = l_tax_ref
   and   nvl(a.AUTHORISED,'N') = 'Y'
   and   b.DEAL_TYPE           = l_deal_type
   and   b.CALC_TYPE           = a.CALC_TYPE
   and   b.AMOUNT_TYPE         = l_tax_amt_type
   and   d.RATE_GROUP          = a.RATE_GROUP
   and   d.REF_TYPE            = 'T'
   and   d.EFFECTIVE_FROM     <= l_deal_date
   and   nvl(d.MIN_AMT,0)     <= l_tax_amt
   and   (d.MAX_AMT >= l_tax_amt or d.MAX_AMT is NULL)
   order by d.EFFECTIVE_FROM desc;

Line: 382

  select round((l_tax_out / s.hce_rate),nvl(rounding_factor,2)),
	 round((l_bkge_out / s.hce_rate),nvl(rounding_factor,2))
   from  XTR_MASTER_CURRENCIES_V s
   where s.CURRENCY   = l_ccy;

Line: 389

  select YEAR_BASIS
   from XTR_MASTER_CURRENCIES
   where CURRENCY = l_ccy;

Line: 546

  select b.CALC_BASIS, b.CALC_TYPE, nvl(d.INTEREST_RATE,0)
   from  XTR_TAX_BROKERAGE_SETUP a,
	 XTR_TAX_DEDUCTION_CALCS b,
         XTR_TAX_BROKERAGE_RATES d
   where a.REFERENCE_CODE      = l_tax_ref
   and   nvl(a.AUTHORISED,'N') = 'Y'
   and   b.DEAL_TYPE           = l_deal_type
   and   b.CALC_TYPE           = a.CALC_TYPE
   and   d.RATE_GROUP          = a.RATE_GROUP
   and   d.REF_TYPE            = 'T'
   and   d.EFFECTIVE_FROM     <= l_deal_date
   order by d.EFFECTIVE_FROM desc;

Line: 561

   select tax_rounding_rule, tax_rounding_precision
   from XTR_TAX_BROKERAGE_SETUP
   where reference_code = l_ref;

Line: 646

	SELECT tax_settle_method
	FROM XTR_TAX_BROKERAGE_SETUP
	WHERE reference_code = l_tax_ref;

Line: 668

      SELECT precision
      FROM fnd_currencies
      WHERE currency_code = l_ccy;

Line: 713

  select NAME, YEAR_BASIS, ROUNDING_FACTOR
   from  XTR_MASTER_CURRENCIES_V
   where CURRENCY   = l_currency;

Line: 737

  select SHORT_NAME
   from  XTR_PARTIES_V
   where PARTY_CODE = l_client_code
   and   PARTY_TYPE = 'CP'
   and   PARTY_CATEGORY = 'CL'
   and   AUTHORISED = 'Y';

Line: 745

  select SHORT_NAME
   from  XTR_PARTY_INFO_V
   where PARTY_CODE = l_client_code;

Line: 774

  select dealer_code
  from xtr_dealer_codes_v
  where user_id = fnd_user;

Line: 779

  select p.SHORT_NAME
   from XTR_PARTIES_V p
   where p.PARTY_CODE = l_company_code
   and p.PARTY_TYPE = 'C'
   and p.AUTHORISED = 'Y'
   and p.party_code in(select c.party_code
                        from XTR_COMPANY_AUTHORITIES c
                        where c.dealer_code = l_user
                        and c.company_authorised_for_input='Y');

Line: 790

  select p.SHORT_NAME
   from XTR_PARTY_INFO_V p
   where p.PARTY_CODE = l_company_code;

Line: 823

 select ACCOUNT_NUMBER
  from  XTR_BANK_ACCOUNTS
  where PARTY_CODE = l_cparty_code
  and   BANK_SHORT_CODE = l_cparty_ref
  and   CURRENCY = l_currency;

Line: 850

  select SHORT_NAME
   from  XTR_PARTIES_V
   where PARTY_CODE = l_cparty_code
   and   PARTY_TYPE in('CP','C')
   and   AUTHORISED = 'Y';

Line: 857

  select SHORT_NAME
   from  XTR_PARTY_INFO_V
   where PARTY_CODE = l_cparty_code;

Line: 884

  select 1
   from  XTR_COUNTERPARTY_LIMITS cpl
   where cpl.CPARTY_CODE  = l_cparty_code
   and   cpl.COMPANY_CODE = l_company_code
   and   cpl.LIMIT_CODE   = l_limit_code
   and   (cpl.EXPIRY_DATE >= trunc(sysdate) or
            cpl.EXPIRY_DATE is NULL);

Line: 913

 select 1
  from  XTR_DEALER_CODES
  where DEALER_CODE = l_dealer_code;

Line: 938

  select   1
   from    XTR_DEALS_V
   where   deal_no     = l_deal_number
   and     status_code = 'CURRENT';

Line: 949

   l_err_code := 58; l_level := 'E';--This deal is not CURRENT and cannot be updated