The following lines contain the word 'select', 'insert', 'update' or 'delete':
select location_id
into p_location_id
from hr_locations_all
where location_code = P_location;
select organization_name
into l_org_displayed
from org_organization_definitions
where organization_id = P_org_id ;
select structure_id
into l_p_struct_num
from mtl_default_sets_view
where functional_area_id = 2 ;
SELECT manual_po_num_type
, manual_req_num_type
INTO po_numbering_type
, req_numbering_type
FROM po_system_parameters;
select hrtl.location_code
into x_location_code
from hr_locations_all hrl,
hr_locations_all_tl hrtl
where hrl.location_id = location_id1
and hrl.location_id = hrtl.location_id
and hrtl.language = userenv('LANG');
select substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,20) location_code
into x_location_code
from hz_locations hz
where hz.location_id = location_id1;
select location_id
into p_location_id
from hr_locations_all
where location_code = P_location;