The following lines contain the word 'select', 'insert', 'update' or 'delete':
select segment1
from pa_projects_all
where project_id = arg_project_id
union
select project_number
from mrp_seiban_numbers
where project_id = arg_project_id;
select task_number
into var_task_num
from pa_tasks
where task_id = arg_task_id;
select DISTINCT planning_group
into var_plng_grp
from mrp_project_parameters
where project_id = arg_project_id;
select meaning
from fnd_lookups
where lookup_type = arg_lookup_type and lookup_code = arg_lookup_code;
select lv.meaning
into meaning_text
from mfg_lookups lv
where lv.lookup_type = arg_lookup_type
and lv.lookup_code = arg_lookup_code;
select organization_code
into org_code
from mtl_parameters
where organization_id = arg_org_id;
select concatenated_segments
into item_text
from mtl_system_items_kfv
where organization_id = arg_org_id
and inventory_item_id = arg_item_id;
select description
into item_desc
from mtl_system_items_kfv
where organization_id = arg_org_id
and inventory_item_id = arg_item_id;
select mcvl.description
into category_desc
from mtl_categories_vl mcvl,
mtl_category_sets mcs
where mcs.category_set_id = arg_cat_set_id
and mcs.structure_id = mcvl.structure_id
and mcvl.category_id = arg_cat_id;
select concatenated_segments
into category_name
from mtl_categories_kfv
where category_id = arg_cat_id;
select P.party_name
into cust_name
from HZ_CUST_ACCOUNTS A,
HZ_PARTIES P
where A.cust_account_id = arg_cust_id
AND A.PARTY_ID = P.PARTY_ID ;
select A.address1
into address_name
from hz_locations A,
HZ_PARTY_SITES PS1,
HZ_CUST_ACCT_SITES_ALL AS1,
hz_cust_site_uses_all SU
where SU.site_use_id = arg_site_id
AND SU.CUST_ACCT_SITE_ID = AS1.CUST_ACCT_SITE_ID
AND AS1.PARTY_SITE_ID = PS1.PARTY_SITE_ID
AND PS1.LOCATION_ID = A.LOCATION_ID ;
SELECT vendor_site_code INTO v_vendor_site_code
FROM po_vendor_sites_all site,
org_organization_definitions ood
WHERE site.vendor_site_id = arg_vendor_site_id
AND nvl(site.org_id,nvl(ood.operating_unit,-1)) =
nvl(ood.operating_unit,-1)
AND ood.organization_id = arg_org_id;