The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ship_method
INTO l_ship_method
FROM mtl_interorg_ship_methods
WHERE from_location_id = p_from_location_id
AND to_location_id = p_to_location_id
AND default_flag = 1
AND rownum = 1;
SELECT intransit_time
INTO l_intransit_time
FROM mtl_interorg_ship_methods
WHERE from_location_id = p_from_location_id
AND to_location_id = p_to_location_id
AND default_flag = 1
AND rownum = 1;
select ship_method
into l_ship_method
from mtl_interorg_ship_methods
where from_organization_id = p_from_org_id
and to_organization_id = p_to_org_id
and default_flag = 1
and rownum = 1;
select intransit_time
into l_intransit_time
from mtl_interorg_ship_methods
where from_organization_id = p_from_org_id
and to_organization_id = p_to_org_id
and ship_method = p_source_ship_method
and rownum = 1;
select intransit_time
into l_intransit_time
from mtl_interorg_ship_methods
where from_organization_id = p_from_org_id
and to_organization_id = p_to_org_id
and default_flag = 1
and rownum = 1;