APPS.QRM_CALCULATORS_P SQL Statements

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

Line: 114

    SELECT param_value INTO p_ccy
	FROM xtr_pro_param WHERE param_name = 'SYSTEM_FUNCTIONAL_CCY';

Line: 339

    p_rate_types.delete;

Line: 340

    p_base_currencies.delete;

Line: 341

    p_data_sides.delete;

Line: 506

    p_base_currencies.delete;

Line: 1285

	  SELECT curve_code
	  FROM xtr_rm_md_curves
	  WHERE type=p_type and authorized_yn='Y' and ccy=p_base_ccy
	  ORDER BY creation_date;

Line: 1293

	SELECT curve_code
	FROM xtr_rm_md_curves
	WHERE type=p_type and authorized_yn='Y' and
		(ccy=p_base_ccy and contra_ccy=p_contra_ccy) or
		(ccy=p_contra_ccy and contra_ccy=p_base_ccy)
	ORDER BY creation_date;

Line: 1398

     	    SELECT usd_base_curr_bid_rate bid_rate_comm,
		   usd_base_curr_offer_rate ask_rate_comm,
		   1/usd_base_curr_offer_rate bid_rate_base,
		   1/usd_base_curr_bid_rate ask_rate_base,
		   currency
  	    FROM xtr_spot_rates
	    WHERE (rate_date, currency) IN
		(SELECT MAX(rate_date), currency
		 FROM xtr_spot_rates
		 WHERE currency IN (p_base_ccy)
			AND currency <> 'USD'
			AND trunc(rate_date) <= trunc(p_spot_date)
		 GROUP BY currency);

Line: 1758

	    SELECT currency_a, currency_b
  	    FROM xtr_market_prices
	    WHERE p_ccy IN (currency_a, currency_b) AND term_type='S';

Line: 1854

  select param_value from xtr_pro_param
      where param_name = 'SYSTEM_FUNCTIONAL_CCY';

Line: 1910

      select data_side into v_quote_basis from xtr_rm_md_curves where
      curve_code = p_rate_curve;

Line: 1949

      select data_side into v_quote_basis from xtr_rm_md_curves where
      curve_code = p_rate_curve;

Line: 2092

  select param_value from xtr_pro_param
      where param_name = 'SYSTEM_FUNCTIONAL_CCY';

Line: 2313

      SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';

Line: 2315

      SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';

Line: 2321

      SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';

Line: 2323

      SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';

Line: 2590

    			p_rate_types.delete;

Line: 2591

    			p_base_currencies.delete;

Line: 2592

    			p_data_sides.delete;

Line: 2724

    			p_base_currencies.delete;

Line: 3171

    			p_rate_types.delete;

Line: 3172

    			p_base_currencies.delete;

Line: 3173

    			p_data_sides.delete;

Line: 3202

				p_rate_types.delete;

Line: 3203

    				p_base_currencies.delete;

Line: 3204

    				p_data_sides.delete;

Line: 3205

				p_contra_currencies.delete;

Line: 3357

    			p_base_currencies.delete;

Line: 3391

				p_rate_types.delete;

Line: 3392

    				p_base_currencies.delete;

Line: 3393

    				p_data_sides.delete;

Line: 3394

				p_contra_currencies.delete;