The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT time_recipient_id
FROM hxc_time_recipients
WHERE name = p_time_recipient;
SELECT retrieval_process_id
, object_version_number
, DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
INTO l_retrieval_process_id
, l_ovn
, l_owner
FROM hxc_retrieval_processes
WHERE name = P_NAME;
hxc_retrieval_processes_api.update_retrieval_processes (
p_name => p_name
, p_time_recipient_id => l_time_recipient_id
, p_mapping_id => l_mapping_id
, p_retrieval_process_id => l_retrieval_process_id
, p_object_version_number => l_ovn );