The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
NVL(org_id,-99)
INTO
l_org_id
FROM
po_vendor_sites_all
WHERE vendor_site_id = p_vendor_site_id;
SELECT
primary_unit_of_measure
INTO
l_uom
FROM
mtl_system_items
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = p_organization_id;
SELECT
uom_code
INTO
l_uom_code
FROM
mtl_units_of_measure
WHERE unit_of_measure = p_unit_of_measure;
SELECT
location_id
INTO
l_location_id
FROM
hr_all_organization_units
WHERE organization_id = p_organization_id;
SELECT haou.location_id
INTO l_location_id
FROM hr_all_organization_units haou,
hr_operating_units hou
WHERE haou.organization_id = hou.organization_id;
SELECT
pov.vendor_name
, povs.vendor_site_code
INTO
x_vendor_name
, x_vendor_site_code
FROM
po_vendors pov
, po_vendor_sites_all povs
WHERE pov.vendor_id = povs.vendor_id
AND povs.vendor_site_id = p_vendor_site_id;