The following lines contain the word 'select', 'insert', 'update' or 'delete':
select party_name
from hz_parties
where party_id = p_to_fk_id;
select merge_reason_code
into l_merge_reason_code
from hz_merge_batch
where batch_id = p_batch_id;
-- obtain lock on records to be updated.
arp_message.set_name('AR', 'AR_LOCKING_TABLE');
update JTF_FM_PREVIEWS
set fm_party_id = p_to_fk_id,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login
where fm_party_id = p_from_fk_id;
update JTF_FM_PROCESSED
set party_id = p_to_fk_id,
party_name = l_party_name,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login
where party_id = p_from_fk_id;
update JTF_FM_CONTENT_HISTORY
set party_id = p_to_fk_id,
party_name = l_party_name,
last_update_date = hz_utility_pub.last_update_date,
last_updated_by = hz_utility_pub.user_id,
last_update_login = hz_utility_pub.last_update_login
where party_id = p_from_fk_id;
arp_message.set_name('AR', 'AR_ROWS_UPDATED');