The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT party_type
INTO l_category
FROM hz_parties
WHERE party_id = p_bookmarked_party_id;
SELECT party_name, party_type
INTO l_party_name, l_category
FROM hz_parties
WHERE party_id = p_bookmarked_party_id;
SELECT count(*)
INTO l_bookmark_num
FROM HZ_PARTY_PREFERENCES
WHERE MODULE = G_MODLUE
AND CATEGORY = l_category
AND PREFERENCE_CODE = G_PREFERENCE_CODE
AND PARTY_ID = p_party_id;
SELECT user_name, email_address, customer_id, employee_id
INTO l_user_name, l_email_address, l_party_id, l_person_id
FROM fnd_user
WHERE user_id = p_fnd_user_id;
fnd_user_pkg.updateuser(x_user_name=>l_user_name,
x_owner=>'SEED',
x_customer_id=>l_party_id);
select customer_id into l_user_id
from fnd_user
where user_id = p_party_id;
SELECT party_id
INTO l_party_id
FROM hz_parties
WHERE party_id = p_party_id;
SELECT value_number
FROM HZ_PARTY_PREFERENCES
WHERE MODULE = G_MODLUE
AND CATEGORY = p_bookmarked_party_type
AND PREFERENCE_CODE = G_PREFERENCE_CODE
AND PARTY_ID = p_party_id;
SELECT value_number
FROM HZ_PARTY_PREFERENCES
WHERE MODULE = G_MODLUE
AND PREFERENCE_CODE = G_PREFERENCE_CODE
AND PARTY_ID = p_party_id;
select customer_id into l_user_id
from fnd_user
where user_id = p_party_id;
select count(*) into l_count
from hz_relationships
where party_id = p_party_id
and subject_type = 'ORGANIZATION'
and object_type = 'ORGANIZATION';
SELECT per.person_id,
per.first_name,
per.last_name,
per.email_address
FROM per_all_people_f per
WHERE per.person_id = l_per_person_id
AND TRUNC(SYSDATE) BETWEEN effective_start_date
AND effective_end_date;
select hz_party_number_s.nextval into par_rec.party_number from dual;