APPS.HR_APPLICANT_BE1 SQL Statements

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

Line: 100

p_resume_last_updated          date,
p_student_status               varchar2,
p_work_schedule                varchar2,
p_suffix                       varchar2,
p_date_of_death                date,
p_benefit_group_id             number,
p_receipt_of_death_cert_date   date,
p_coord_ben_med_pln_no         varchar2,
p_coord_ben_no_cvg_flag        varchar2,
p_uses_tobacco_flag            varchar2,
p_dpdnt_adoption_date          date,
p_dpdnt_vlntry_svce_flag       varchar2,
p_original_date_of_hire        date,
p_person_id                    number,
p_assignment_id                number,
p_application_id               number,
p_per_object_version_number    number,
p_asg_object_version_number    number,
p_apl_object_version_number    number,
p_per_effective_start_date     date,
p_per_effective_end_date       date,
p_full_name                    varchar2,
p_per_comment_id               number,
p_assignment_sequence          number,
p_name_combination_warning     boolean,
p_orig_hire_warning            boolean,
p_town_of_birth                varchar2,
p_region_of_birth              varchar2,
p_country_of_birth             varchar2,
p_global_person_id             varchar2,
p_party_id                     varchar2,
p_vacancy_id                   number) is
  l_event_key number;

Line: 139

  select per_wf_events_s.nextval from dual;

Line: 545

    l_text:='';

Line: 546

    l_text:=l_text||fnd_date.date_to_canonical(p_resume_last_updated);

Line: 547

    l_text:=l_text||'';