The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
api_hook_id,
api_module_id,
api_hook_type,
hook_package,
hook_procedure,
legislation_code,
legislation_package,
legislation_function,
encoded_error
from hr_api_hooks
where api_hook_id = p_api_hook_id;
select api_hook_id,
api_module_id,
api_hook_type,
hook_package,
hook_procedure,
legislation_code,
legislation_package,
legislation_function,
encoded_error
from hr_api_hooks
where api_hook_id = p_api_hook_id
for update nowait;