The following lines contain the word 'select', 'insert', 'update' or 'delete':
select end_date
from per_time_periods
where time_period_id = p_time_period_id;
insert into fnd_sessions (session_id, effective_date)
select userenv('sessionid'), trunc(l_session_date)
from dual
where not exists
(select 1
from fnd_sessions fs
where fs.session_id = userenv('sessionid'));
select session_id
into l_test
from fnd_sessions
where session_id = userenv('sessionid');
Select segment_name into b from fnd_id_flex_segments_vl
where application_id between 801 and 899
and id_flex_code = 'GRP'
and application_column_name = a
and id_flex_num = (Select people_group_structure from per_business_groups
Where business_group_id = p_bus_grp_id);
select currency_code
into currency_code
from per_business_groups
where business_group_id=p_bus_grp_id;