The following lines contain the word 'select', 'insert', 'update' or 'delete':
select fu.user_id
into l_user_id
from fnd_user fu
where fu.employee_id = p_employee_id
and sysdate >= fu.start_date
and sysdate <= nvl(fu.end_date, sysdate)
and rownum = 1;
select round(p_amount, fc.precision)
into l_value
from fnd_currencies_vl fc
where currency_code = p_curr_code;
select menu_id, responsibility_id
into l_menu_id, l_responsibility_id
from (
select fr.menu_id, fr.responsibility_id
from fnd_responsibility fr,
fnd_user_resp_groups furg
where fr.application_id = 200
and fr.version = 'W'
and furg.user_id = p_user_id
and furg.responsibility_id = fr.responsibility_id
order by furg.start_date desc
)
where rownum=1;
select base_currency_code, asp.set_of_books_id, asp.default_exchange_rate_type
into l_curr_code, l_sob_id, l_default_exchange_rate_type
from ap_system_parameters_all asp
where asp.org_id = p_org_id;
select asp.default_exchange_rate_type
into l_exchange_rate_type
from per_employees_x pex,
ap_system_parameters_all asp,
fnd_user fu
where
pex.set_of_books_id = asp.set_of_books_id and
fu.employee_id = pex.employee_id and
fu.user_id = p_userid and
rownum = 1;
SELECT set_of_books_id
INTO l_sob_id
FROM
(SELECT set_of_books_id
FROM per_employees_x emp
WHERE employee_id = l_employee_id
AND NOT AP_WEB_DB_HR_INT_PKG.isPersonCwk(emp.employee_id)='Y'
UNION ALL
SELECT set_of_books_id
FROM per_cont_workers_current_x emp
WHERE person_id = l_employee_id
);
SELECT currency_code INTO l_func_curr_code FROM gl_sets_of_books WHERE set_of_books_id=l_sob_id;
SELECT default_exchange_rate_type
INTO l_exchange_rate_type
FROM ap_system_parameters_all
WHERE set_of_books_id = l_sob_id
AND rownum= 1;