APPS.IRC_SAVED_SEARCH_CRITERIA_BE3 SQL Statements

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

Line: 4

procedure delete_search_criteria_a (
p_vacancy_id                   number,
p_saved_search_criteria_id     number,
p_object_version_number        number) is
  l_event_key number;

Line: 15

  select per_wf_events_s.nextval from dual;

Line: 17

  l_proc varchar2(72):='  irc_saved_search_criteria_be3.delete_search_criteria_a';

Line: 21

  l_event_name:='oracle.apps.per.irc.api.saved_search_criteria.delete_search_criteria';

Line: 79

end delete_search_criteria_a;