APPS.HR_COMPETENCE_ELEMENT_BE7 SQL Statements

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

Line: 4

procedure update_delivered_dates_a (
p_activity_version_id          number,
p_old_start_date               date,
p_start_date                   date,
p_old_end_date                 date,
p_end_date                     date) is
  l_event_key number;

Line: 17

  select per_wf_events_s.nextval from dual;

Line: 19

  l_proc varchar2(72):='  hr_competence_element_be7.update_delivered_dates_a';

Line: 23

  l_event_name:='oracle.apps.per.api.competence_element.update_delivered_dates';

Line: 89

end update_delivered_dates_a;