The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT common_routing_sequence_id into l_common_rout_seq_id
from msc_routings mr
where mr.plan_id = -1
and mr.sr_instance_id = p_sr_instance_id
and mr.organization_id = p_org_id
and mr.assembly_item_id = p_inventory_item_id;
select bom_item_type into l_parent_item_type
from msc_system_items msi,
msc_routings mr
where mr.routing_sequence_id = l_common_rout_seq_id
and mr.sr_instance_id = p_sr_instance_id
and mr.plan_id = -1
and mr.organization_id = p_org_id
and msi.inventory_item_id = mr.assembly_item_id
and msi.sr_instance_id = mr.sr_instance_id
and msi.organization_id = mr.organization_id
and msi.plan_id = mr.plan_id;