The following lines contain the word 'select', 'insert', 'update' or 'delete':
select application_id
from fnd_application
where application_short_name = p_appl_short_name;
select count(*)
from fnd_id_flex_segments
where id_flex_code = p_flex_code
and id_flex_num = p_flex_num
and application_id = p_application_id
and enabled_flag = 'Y';
select EFFECTIVE_DATE from fnd_sessions
where session_id=userenv('sessionid');
select EFFECTIVE_DATE from fnd_sessions
where session_id=userenv('sessionid');
select substr(application_column_name,8,2)
from fnd_id_flex_segments_vl
where id_flex_code = p_flex_code
and id_flex_num = p_flex_num
and enabled_flag='Y'
and application_id = p_application_id
order by to_number(substr(application_column_name,8,2));
select substr(application_column_name,8,2)
from fnd_id_flex_segments_vl
where id_flex_code = p_flex_code
and id_flex_num = p_flex_num
and enabled_flag = 'Y'
and application_id = p_application_id
order by segment_num;
g_kfcode_structure.delete;
l_parameter_updated fnd_flex_ext.SegmentArray;
select substr(application_column_name,8,2)
from fnd_id_flex_segments_vl
where id_flex_code = p_flex_code
and id_flex_num = p_flex_num
and enabled_flag='Y'
and application_id = l_application_id --3456567 to avoid FTS
order by to_number(substr(application_column_name,8,2));
l_parameter_updated(i) := hr_api.g_varchar2;
l_parameter_updated(l_seg_num) :=
l_parameter_original(array_counter);
l_parameter_updated(l_seg_num) := nvl(l_parameter_new(l_seg_num), NULL);
,p_parameter => l_parameter_updated
,p_too_many_segs => l_too_many_segs
,p_ccid => p_ccid
,p_concat_segments_out => p_concat_segments_out
);
select 1 from fnd_sessions
where session_id=userenv('sessionid');
delete from fnd_sessions
where session_id=p_session_id;