The following lines contain the word 'select', 'insert', 'update' or 'delete':
select module_id
from pay_au_modules pam
where pam.name = p_name
and (pam.business_group_id is null
or pam.business_group_id = p_business_group_id)
and pam.legislation_code = p_legislation_code;
procedure delete_au_module
(p_validate in boolean default false,
p_module_id in number,
p_object_version_number in number) is
--
l_proc varchar2(72);
l_proc := g_package||'delete_au_module';
savepoint delete_au_module;
ROLLBACK TO delete_au_module;
end delete_au_module;
procedure update_au_module
(p_validate in boolean default false,
p_module_id in number,
p_name in varchar2,
p_enabled_flag in varchar2,
p_module_type_id in number,
p_business_group_id in number,
p_legislation_code in varchar2,
p_description in varchar2,
p_package_name in varchar2,
p_procedure_function_name in varchar2,
p_formula_name in varchar2,
p_object_version_number in out nocopy number
) is
--
l_proc varchar2(72);
l_proc := g_package||'update_au_module';
savepoint update_au_module;
ROLLBACK TO update_au_module;
end update_au_module;