The following lines contain the word 'select', 'insert', 'update' or 'delete':
IS SELECT merge_reason_code
FROM hz_merge_batch
WHERE batch_id = p_batch_id;
UPDATE jtf_notes_b
SET source_object_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 source_object_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
, jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = 'NOTES'
AND ojt.from_table ='HZ_PARTIES'
)
AND source_object_id = p_from_fk_id;
UPDATE jtf_notes_b
SET source_object_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 source_object_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
, jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = 'NOTES'
AND ojt.from_table ='HZ_PARTY_SITES'
)
AND source_object_id = p_from_fk_id;
IS SELECT merge_reason_code
FROM hz_merge_batch
WHERE batch_id = p_batch_id;
UPDATE jtf_note_contexts
SET note_context_type_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 note_context_type IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
, jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = 'NOTES'
AND ojt.from_table ='HZ_PARTIES'
)
AND note_context_type_id = p_from_fk_id;
UPDATE jtf_note_contexts
SET note_context_type_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 note_context_type IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
, jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = 'NOTES'
AND ojt.from_table ='HZ_PARTY_SITES'
)
AND note_context_type_id = p_from_fk_id;