APPS.HR_EMPLOYEE_BE1 SQL Statements

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

Line: 107

p_resume_last_updated          date,
p_second_passport_exists       varchar2,
p_student_status               varchar2,
p_work_schedule                varchar2,
p_suffix                       varchar2,
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_coord_ben_med_ext_er         varchar2,
p_coord_ben_med_pl_name        varchar2,
p_coord_ben_med_insr_crr_name  varchar2,
p_coord_ben_med_insr_crr_ident varchar2,
p_coord_ben_med_cvg_strt_dt    date,
p_coord_ben_med_cvg_end_dt     date,
p_uses_tobacco_flag            varchar2,
p_dpdnt_adoption_date          date,
p_dpdnt_vlntry_svce_flag       varchar2,
p_original_date_of_hire        date,
p_adjusted_svc_date            date,
p_person_id                    number,
p_assignment_id                number,
p_per_object_version_number    number,
p_asg_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_assignment_number            varchar2,
p_town_of_birth                varchar2,
p_region_of_birth              varchar2,
p_country_of_birth             varchar2,
p_global_person_id             varchar2,
p_party_id                     number,
p_name_combination_warning     boolean,
p_assign_payroll_warning       boolean,
p_orig_hire_warning            boolean) is
  l_event_key number;

Line: 152

  select per_wf_events_s.nextval from dual;

Line: 586

    l_text:='';

Line: 587

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

Line: 588

    l_text:=l_text||'';