The following lines contain the word 'select', 'insert', 'update' or 'delete':
select structure_id
into l_p_struct_num
from mtl_default_sets_view
where functional_area_id = 2 ;
select gsob.chart_of_accounts_id
into l_chart_of_accounts_id
from gl_sets_of_books gsob,
financials_system_parameters fsp
where fsp.set_of_books_id = gsob.set_of_books_id ;
select short_text
into short_note
from fnd_documents_short_text
where media_id = line_note_media_id;
select long_text
into long_note
from fnd_documents_long_text
where media_id = line_note_media_id;
select short_text
into short_note
from fnd_documents_short_text
where media_id = item_note_media_id;
select long_text
into long_note
from fnd_documents_long_text
where media_id = item_note_media_id;
select short_text
into short_note
from fnd_documents_short_text
where media_id = header_note_media_id;
select long_text
into long_note
from fnd_documents_long_text
where media_id = header_note_media_id;