APPS.HR_ASSIGNMENT_BEP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

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;

Line: 25

  select per_wf_events_s.nextval from dual;

Line: 27

  l_proc varchar2(72):='  hr_assignment_beP.delete_assignment_a';

Line: 31

  l_event_name:='oracle.apps.per.api.assignment.delete_assignment';

Line: 71

    l_text:='';

Line: 72

if(P_DELETE_ASG_BUDGETS) then
l_text:=l_text||'TRUE';

Line: 77

    l_text:=l_text||'';

Line: 167

end delete_assignment_a;