The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT meaning
from ar_lookups
where lookup_type = in_lookup_type
and lookup_code = in_lookup_code;
select hz_party_number_s.nextval
into l_party_rec.party_number
from dual;
select hz_party_number_s.nextval
into l_org_contact_rec.party_rel_rec.party_rec.party_number
from dual;
Select party_type
Into l_org_contact_rec.party_rel_rec.object_type
From HZ_PARTIES
Where party_id = p_party_id;
select hz_contact_numbers_s.nextval
into l_org_contact_rec.contact_number
from dual;
select party_name
into x_contact_name
from hz_parties
where party_id = x_party_id;
SELECT email_address
FROM hz_contact_points
WHERE owner_table_id = p_contact_party_id
AND owner_table_name = 'HZ_PARTIES'
AND contact_point_type = 'EMAIL'
AND primary_flag = 'Y'
AND status = 'A'; */
SELECT email_address
fROM hz_parties
where party_id = p_contact_party_id;
select hz_contact_points_s.nextval
into l_contact_points_rec.contact_point_id
from dual;
select *
into sysparm
from ar_system_parameters;
select territory_short_name,address_style
into out_default_country,out_address_style
from fnd_territories_vl
where territory_code = out_default_country_code;
select party_name
into out_cust_name
from hz_parties
where party_id = x_party_id;
select party.party_id,
party.party_name,
acct.account_number,
party.party_number
into x_party_id,
out_cust_name,
out_cust_number,
out_party_number
from hz_cust_accounts acct,
hz_parties party
where acct.cust_account_id = in_cust_account_id
and party.party_id = acct.party_id;
select location
into out_ship_to_location
from hz_cust_site_uses_all
where site_use_id = x_site_use_id;
select location
into out_bill_to_location
from hz_cust_site_uses_all
where site_use_id = x_site_use_id;
select location
into out_deliver_to_location
from hz_cust_site_uses_all
where site_use_id = x_site_use_id;
select location
into out_sold_to_location
from hz_cust_site_uses_all
where site_use_id = x_site_use_id;
select in_cont_last_name||
DECODE(in_cont_first_name,NULL,NULL,', '||in_cont_first_name)||
DECODE(in_cont_title,NULL,NULL,' '||in_cont_title)
into out_cont_Name
from dual;