The following lines contain the word 'select', 'insert', 'update' or 'delete':
select process_id from pay_au_processes pap
where pap.legislation_code = p_legislation_code
and (pap.business_group_id is null
or pap.business_group_id = p_business_group_id)
and (pap.short_name = p_short_name
or pap.name = p_name);
procedure delete_au_process
(p_validate in boolean default false,
p_process_id in number,
p_object_version_number in number) is
--
l_proc varchar2(72);
l_proc := g_package||'delete_au_process';
savepoint delete_au_process;
ROLLBACK TO delete_au_process;
end delete_au_process;
procedure update_au_process
(p_validate in boolean default false,
p_process_id in number,
p_short_name in varchar2,
p_name in varchar2,
p_enabled_flag in varchar2,
p_business_group_id in number,
p_legislation_code in varchar2,
p_description in varchar2,
p_accrual_category in varchar2,
p_object_version_number in out nocopy number
) is
--
l_proc varchar2(72);
l_proc := g_package||'update_au_process';
savepoint update_au_process;
ROLLBACK TO update_au_process;
end update_au_process;