APPS.HR_EDW_WRK_SPRTN_F_C SQL Statements

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

Line: 15

 l_rows_inserted            Number:=0;

Line: 73

   Insert Into HR_EDW_WRK_SPRTN_FSTG(
     separation_pk,
     assignment_fk,
     age_band_fk,
     service_band_fk,
     geography_fk,
     grade_fk,
     instance_fk,
     job_fk,
     organization_fk,
     person_fk,
     person_type_fk,
     position_fk,
     time_trm_ntfd_fk,
     time_emp_strt_fk,
     time_trm_accptd_fk,
     time_trm_prjctd_fk,
     time_trm_prcss_fk,
     time_trm_occrd_fk,
     reason_fk,
     movement_type_fk,
     asg_assignment_id,
     asg_business_group_id,
     asg_grade_id,
     asg_job_id,
     asg_location_id,
     asg_organization_id,
     asg_person_id,
     asg_position_id,
     pps_prd_of_srvc_id,
     pps_trm_acptd_prsn_id,
     date_of_birth,
     last_update_date,
     creation_date,
     emp_start_fte,
     emp_start_hdcnt,
     sprtn_ntfd_fte,
     sprtn_ntfd_hdcnt,
     sprtn_accptd_fte,
     sprtn_accptd_hdcnt,
     sprtn_prjctd_fte,
     sprtn_prjctd_hdcnt,
     emp_sprtn_fte,
     emp_sprtn_hdcnt,
     final_prcss_fte,
     final_prcss_hdcnt,
     separation_fte,
     separation_headcount,
     dys_frm_strt_to_lst_updt,
     dys_frm_strt_to_lst_updt_asg,
     latest_asg_duration,
     sprtn_ntfd_vl,
     sprtn_accptd_vl,
     sprtn_plnd_vl,
     sprtn_cncld_vl,
     sprtn_occrrd_vl,
     sprtn_fnl_prcssng_vl,
     dys_frm_strt_to_ntfd_asg,
     dys_frm_strt_to_accptd_asg,
     dys_frm_strt_to_plnd_asg,
     dys_frm_strt_to_trm_asg,
     dys_frm_strt_to_prcss_asg,
     dys_frm_strt_to_ntfd,
     dys_frm_strt_to_accptd,
     dys_frm_strt_to_plnd,
     dys_frm_strt_to_trm,
     dys_frm_strt_to_prcss,
     dys_frm_ntfd_to_acptd,
     dys_frm_ntfd_to_plnd,
     dys_frm_ntfd_to_ocrd,
     dys_frm_acptd_to_plnd,
     dys_frm_acptd_to_ocrd,
     ntfd_trmntn_dt,
     accptd_trmntn_dt,
     prjctd_trmntn_dt,
     actual_trmntn_dt,
     final_process_dt,
     leaving_reason,
     user_measure1,
     user_measure2,
     user_measure3,
     user_measure4,
     user_measure5,
     user_attribute1,
     user_attribute2,
     user_attribute3,
     user_attribute4,
     user_attribute5,
     user_attribute6,
     user_attribute7,
     user_attribute8,
     user_attribute9,
     user_attribute10,
     user_attribute11,
     user_attribute12,
     user_attribute13,
     user_attribute14,
     user_attribute15,
     user_fk1,
     user_fk2,
     user_fk3,
     user_fk4,
     user_fk5,
     operation_code,
     collection_status)
   select
     separation_pk,
     NVL(assignment_fk,'NA_EDW'),
     NVL(age_band_fk,'NA_EDW'),
     NVL(service_band_fk,'NA_EDW'),
     NVL(geography_fk,'NA_EDW'),
     NVL(grade_fk,'NA_EDW'),
     NVL(instance_fk,'NA_EDW'),
     NVL(job_fk,'NA_EDW'),
     NVL(organization_fk,'NA_EDW'),
     NVL(person_fk,'NA_EDW'),
     NVL(person_type_fk,'NA_EDW'),
     NVL(position_fk,'NA_EDW'),
     NVL(time_trm_ntfd_fk,'NA_EDW'),
     NVL(time_emp_strt_fk,'NA_EDW'),
     NVL(time_trm_accptd_fk,'NA_EDW'),
     NVL(time_trm_prjctd_fk,'NA_EDW'),
     NVL(time_trm_prcss_fk,'NA_EDW'),
     NVL(time_trm_occrd_fk,'NA_EDW'),
     NVL(reason_fk,'NA_EDW'),
     NVL(movement_type_fk,'NA_EDW'),
     asg_assignment_id,
     asg_business_group_id,
     asg_grade_id,
     asg_job_id,
     asg_location_id,
     asg_organization_id,
     asg_person_id,
     asg_position_id,
     pps_prd_of_srvc_id,
     pps_trm_acptd_prsn_id,
     date_of_birth,
     last_update_date,
     creation_date,
     emp_start_fte,
     emp_start_hdcnt,
     sprtn_ntfd_fte,
     sprtn_ntfd_hdcnt,
     sprtn_accptd_fte,
     sprtn_accptd_hdcnt,
     sprtn_prjctd_fte,
     sprtn_prjctd_hdcnt,
     emp_sprtn_fte,
     emp_sprtn_hdcnt,
     final_prcss_fte,
     final_prcss_hdcnt,
     separation_fte,
     separation_headcount,
     dys_frm_strt_to_lst_updt,
     dys_frm_strt_to_lst_updt_asg,
     latest_asg_duration,
     sprtn_ntfd_vl,
     sprtn_accptd_vl,
     sprtn_plnd_vl,
     sprtn_cncld_vl,
     sprtn_occrrd_vl,
     sprtn_fnl_prcssng_vl,
     dys_frm_strt_to_ntfd_asg,
     dys_frm_strt_to_accptd_asg,
     dys_frm_strt_to_plnd_asg,
     dys_frm_strt_to_trm_asg,
     dys_frm_strt_to_prcss_asg,
     dys_frm_strt_to_ntfd,
     dys_frm_strt_to_accptd,
     dys_frm_strt_to_plnd,
     dys_frm_strt_to_trm,
     dys_frm_strt_to_prcss,
     dys_frm_ntfd_to_acptd,
     dys_frm_ntfd_to_plnd,
     dys_frm_ntfd_to_ocrd,
     dys_frm_acptd_to_plnd,
     dys_frm_acptd_to_ocrd,
     ntfd_trmntn_dt,
     accptd_trmntn_dt,
     prjctd_trmntn_dt,
     actual_trmntn_dt,
     final_process_dt,
     leaving_reason,
     user_measure1,
     user_measure2,
     user_measure3,
     user_measure4,
     user_measure5,
     user_attribute1,
     user_attribute2,
     user_attribute3,
     user_attribute4,
     user_attribute5,
     user_attribute6,
     user_attribute7,
     user_attribute8,
     user_attribute9,
     user_attribute10,
     user_attribute11,
     user_attribute12,
     user_attribute13,
     user_attribute14,
     user_attribute15,
     NVL(user_fk1,'NA_EDW'),
     NVL(user_fk2,'NA_EDW'),
     NVL(user_fk3,'NA_EDW'),
     NVL(user_fk4,'NA_EDW'),
     NVL(user_fk5,'NA_EDW'),
     NULL, -- OPERATION_CODE
     'READY'
   from HR_EDW_WRK_SPRTN_FCV
   where last_update_date between l_date1 and l_date2;

Line: 285

   l_rows_inserted := sql%rowcount;

Line: 291

   edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
' rows into the staging table');