The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure delete_assignment_a (
p_effective_date date,
p_assignment_id number,
p_datetrack_mode varchar2,
p_loc_change_tax_issues boolean,
p_delete_asg_budgets boolean,
p_org_now_no_manager_warning boolean,
p_element_salary_warning boolean,
p_element_entries_warning boolean,
p_spp_warning boolean,
p_cost_warning boolean,
p_life_events_exists boolean,
p_cobra_coverage_elements boolean,
p_assgt_term_elements boolean) is
l_event_key number;
select per_wf_events_s.nextval from dual;
l_proc varchar2(72):=' hr_assignment_beP.delete_assignment_a';
l_event_name:='oracle.apps.per.api.assignment.delete_assignment';
l_text:='';
if(P_DELETE_ASG_BUDGETS) then
l_text:=l_text||'TRUE';
l_text:=l_text||'';
end delete_assignment_a;