The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT param_value INTO p_ccy
FROM xtr_pro_param WHERE param_name = 'SYSTEM_FUNCTIONAL_CCY';
p_rate_types.delete;
p_base_currencies.delete;
p_data_sides.delete;
p_base_currencies.delete;
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;
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;
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);
SELECT currency_a, currency_b
FROM xtr_market_prices
WHERE p_ccy IN (currency_a, currency_b) AND term_type='S';
select param_value from xtr_pro_param
where param_name = 'SYSTEM_FUNCTIONAL_CCY';
select data_side into v_quote_basis from xtr_rm_md_curves where
curve_code = p_rate_curve;
select data_side into v_quote_basis from xtr_rm_md_curves where
curve_code = p_rate_curve;
select param_value from xtr_pro_param
where param_name = 'SYSTEM_FUNCTIONAL_CCY';
SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';
SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';
SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'REC';
SELECT description INTO p_action FROM xtr_amount_actions_v WHERE deal_type ='FRA' AND amount_type = 'SETTLE' AND action_code = 'PAY';
p_rate_types.delete;
p_base_currencies.delete;
p_data_sides.delete;
p_base_currencies.delete;
p_rate_types.delete;
p_base_currencies.delete;
p_data_sides.delete;
p_rate_types.delete;
p_base_currencies.delete;
p_data_sides.delete;
p_contra_currencies.delete;
p_base_currencies.delete;
p_rate_types.delete;
p_base_currencies.delete;
p_data_sides.delete;
p_contra_currencies.delete;