The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1
INTO l_number
FROM DUAL
WHERE EXISTS (SELECT t.conversion_type
from gl_daily_conversion_types_v t
where t.conversion_type <> 'User'
and t.conversion_type <> 'EMU FIXED'
and t.modify_privilege = 'Y'
and t.conversion_type = p_ratetype);
SELECT currency_code
INTO l_currency_code
FROM gl_sets_of_books
WHERE set_of_books_id = p_sob_id;
SELECT currency_code,
precision,
extended_precision,
derive_type
FROM fnd_currencies
WHERE currency_code = p_ccode
AND enabled_flag = 'Y'
AND currency_flag = 'Y'
AND (start_date_active <= p_effective_date
OR start_date_active IS NULL)
AND (end_date_active >= p_effective_date
OR end_date_active IS NULL);
select to_number(p_factor) into l_var from dual;
/* insert data */
g_action := 'Exchange-rate creation';
itg_debug_pub.Add('PER - Insert into gl_daily_rates_interface' ,1);
INSERT INTO gl_daily_rates_interface(
from_currency, to_currency,
from_conversion_date, to_conversion_date,
user_conversion_type, conversion_rate, mode_flag
) VALUES (
p_currency_from, p_currency_to,
p_effective_date, p_effective_date,
p_ratetype, l_quantity, 'I');
SELECT error_code
FROM gl_daily_rates_interface
WHERE from_currency = p_currency_from
AND to_currency = p_currency_to
AND from_conversion_date = p_effective_date
AND to_conversion_date = p_effective_date
AND user_conversion_type = 'Corporate'
AND mode_flag = 'X';