APPS.HR_PREVIOUS_EMPLOYMENT_BEB SQL Statements

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

Line: 4

procedure update_prev_job_extra_info_a (
p_previous_job_extra_info_id   number,
p_previous_job_id              number,
p_information_type             varchar2,
p_pji_attribute_category       varchar2,
p_pji_attribute1               varchar2,
p_pji_attribute2               varchar2,
p_pji_attribute3               varchar2,
p_pji_attribute4               varchar2,
p_pji_attribute5               varchar2,
p_pji_attribute6               varchar2,
p_pji_attribute7               varchar2,
p_pji_attribute8               varchar2,
p_pji_attribute9               varchar2,
p_pji_attribute10              varchar2,
p_pji_attribute11              varchar2,
p_pji_attribute12              varchar2,
p_pji_attribute13              varchar2,
p_pji_attribute14              varchar2,
p_pji_attribute15              varchar2,
p_pji_attribute16              varchar2,
p_pji_attribute17              varchar2,
p_pji_attribute18              varchar2,
p_pji_attribute19              varchar2,
p_pji_attribute20              varchar2,
p_pji_attribute21              varchar2,
p_pji_attribute22              varchar2,
p_pji_attribute23              varchar2,
p_pji_attribute24              varchar2,
p_pji_attribute25              varchar2,
p_pji_attribute26              varchar2,
p_pji_attribute27              varchar2,
p_pji_attribute28              varchar2,
p_pji_attribute29              varchar2,
p_pji_attribute30              varchar2,
p_pji_information_category     varchar2,
p_pji_information1             varchar2,
p_pji_information2             varchar2,
p_pji_information3             varchar2,
p_pji_information4             varchar2,
p_pji_information5             varchar2,
p_pji_information6             varchar2,
p_pji_information7             varchar2,
p_pji_information8             varchar2,
p_pji_information9             varchar2,
p_pji_information10            varchar2,
p_pji_information11            varchar2,
p_pji_information12            varchar2,
p_pji_information13            varchar2,
p_pji_information14            varchar2,
p_pji_information15            varchar2,
p_pji_information16            varchar2,
p_pji_information17            varchar2,
p_pji_information18            varchar2,
p_pji_information19            varchar2,
p_pji_information20            varchar2,
p_pji_information21            varchar2,
p_pji_information22            varchar2,
p_pji_information23            varchar2,
p_pji_information24            varchar2,
p_pji_information25            varchar2,
p_pji_information26            varchar2,
p_pji_information27            varchar2,
p_pji_information28            varchar2,
p_pji_information29            varchar2,
p_pji_information30            varchar2,
p_object_version_number        number) is
  l_event_key number;

Line: 78

  select per_wf_events_s.nextval from dual;

Line: 80

  l_proc varchar2(72):='  hr_previous_employment_beB.update_prev_job_extra_info_a';

Line: 84

  l_event_name:='oracle.apps.per.api.previous_employment.update_prev_job_extra_info';

Line: 392

end update_prev_job_extra_info_a;