The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
api_module_id,
api_module_type,
module_name,
data_within_business_group,
legislation_code,
module_package
from hr_api_modules
where api_module_id = p_api_module_id;
select api_module_id,
api_module_type,
module_name,
data_within_business_group,
legislation_code,
module_package
from hr_api_modules
where api_module_id = p_api_module_id
for update nowait;