The following lines contain the word 'select', 'insert', 'update' or 'delete':
select userenv('sessionid') sessionid
from dual;
select effective_date,
session_id
from fnd_sessions
where session_id = l_session_id;
update fnd_sessions
set effective_date = p_effective_date
where session_id = l_session_id;
Insert into fnd_sessions
(session_id,effective_date)
values
(l_session_id,p_effective_date);