The following lines contain the word 'select', 'insert', 'update' or 'delete':
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.
SELECT facility_id
INTO l_facility_id
FROM fte_location_parameters
WHERE facility_contact_id = p_from_fk_id
FOR UPDATE NOWAIT;
UPDATE fte_location_parameters
SET facility_contact_id = p_to_fk_id,
last_update_date = hz_utility_v2pub.last_update_date,
last_updated_by = hz_utility_v2pub.user_id,
last_update_login = hz_utility_v2pub.last_update_login,
request_id = hz_utility_v2pub.request_id,
program_application_id = hz_utility_v2pub.program_application_id,
program_id = hz_utility_v2pub.program_id,
program_update_date = sysdate
WHERE facility_contact_id = p_from_fk_id;