eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_EDW_WRK_ACTVTY_F_SIZING SQL Statements

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

Line: 14


  SELECT count(asg.assignment_id) total
  FROM  per_all_assignments_f        asg
  WHERE NVL(asg.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
  BETWEEN p_from_date AND p_to_date;

Line: 66


  x_last_update_date             NUMBER:=x_date;

Line: 119


  x_program_update_date          NUMBER:=x_date;

Line: 131


/* Select the length of the instance code */
  CURSOR inst_cur IS
  SELECT avg(nvl( vsize(instance_code),0 ))
  FROM edw_local_instance;

Line: 137


  SELECT
   avg(nvl(vsize(asg.assignment_id),0))
  ,avg(nvl(vsize(asg.effective_start_date),0))
  ,avg(nvl(vsize(asg.effective_end_date),0))
  ,avg(nvl(vsize(asg.business_group_id),0))
  ,avg(nvl(vsize(asg.recruiter_id),0))
  ,avg(nvl(vsize(asg.grade_id),0))
  ,avg(nvl(vsize(asg.position_id),0))
  ,avg(nvl(vsize(asg.job_id),0))
  ,avg(nvl(vsize(asg.assignment_status_type_id),0))
  ,avg(nvl(vsize(asg.payroll_id),0))
  ,avg(nvl(vsize(asg.location_id),0))
  ,avg(nvl(vsize(asg.person_referred_by_id),0))
  ,avg(nvl(vsize(asg.supervisor_id),0))
  ,avg(nvl(vsize(asg.special_ceiling_step_id),0))
  ,avg(nvl(vsize(asg.person_id),0))
  ,avg(nvl(vsize(asg.recruitment_activity_id),0))
  ,avg(nvl(vsize(asg.source_organization_id),0))
  ,avg(nvl(vsize(asg.organization_id),0))
  ,avg(nvl(vsize(asg.people_group_id),0))
  ,avg(nvl(vsize(asg.soft_coding_keyflex_id),0))
  ,avg(nvl(vsize(asg.vacancy_id),0))
  ,avg(nvl(vsize(asg.pay_basis_id),0))
  ,avg(nvl(vsize(asg.assignment_sequence),0))
  ,avg(nvl(vsize(asg.assignment_type),0))
  ,avg(nvl(vsize(asg.primary_flag),0))
  ,avg(nvl(vsize(asg.application_id),0))
  ,avg(nvl(vsize(asg.assignment_number),0))
  ,avg(nvl(vsize(asg.change_reason),0))
  ,avg(nvl(vsize(asg.comment_id),0))
  ,avg(nvl(vsize(asg.date_probation_end),0))
  ,avg(nvl(vsize(asg.default_code_comb_id),0))
  ,avg(nvl(vsize(asg.employment_category),0))
  ,avg(nvl(vsize(asg.frequency),0))
  ,avg(nvl(vsize(asg.internal_address_line),0))
  ,avg(nvl(vsize(asg.manager_flag),0))
  ,avg(nvl(vsize(asg.normal_hours),0))
  ,avg(nvl(vsize(asg.perf_review_period),0))
  ,avg(nvl(vsize(asg.perf_review_period_frequency),0))
  ,avg(nvl(vsize(asg.period_of_service_id),0))
  ,avg(nvl(vsize(asg.probation_period),0))
  ,avg(nvl(vsize(asg.probation_unit),0))
  ,avg(nvl(vsize(asg.sal_review_period),0))
  ,avg(nvl(vsize(asg.sal_review_period_frequency),0))
  ,avg(nvl(vsize(asg.set_of_books_id),0))
  ,avg(nvl(vsize(asg.source_type),0))
  ,avg(nvl(vsize(asg.time_normal_finish),0))
  ,avg(nvl(vsize(asg.time_normal_start),0))
  ,avg(nvl(vsize(asg.request_id),0))
  ,avg(nvl(vsize(asg.program_application_id),0))
  ,avg(nvl(vsize(asg.program_id),0))
  ,avg(nvl(vsize(asg.program_update_date),0))
  ,avg(nvl(vsize(asg.title),0))
  ,avg(nvl(vsize(asg.object_version_number),0))
  ,avg(nvl(vsize(asg.bargaining_unit_code),0))
  ,avg(nvl(vsize(asg.labour_union_member_flag),0))
  ,avg(nvl(vsize(asg.hourly_salaried_code),0))
  ,avg(nvl(vsize(asg.contract_id),0))
  ,avg(nvl(vsize(asg.collective_agreement_id),0))
  ,avg(nvl(vsize(asg.cagr_id_flex_num),0))
  ,avg(nvl(vsize(asg.cagr_grade_def_id),0))
  ,avg(nvl(vsize(asg.establishment_id),0))
  FROM per_all_assignments_f asg
  WHERE asg.last_update_date BETWEEN p_from_date AND p_to_date;

Line: 260


  ,x_program_update_date
  ,x_asg_title
  ,x_object_version_number
  ,x_bargaining_unit_code
  ,x_labour_union_member_flag
  ,x_hourly_salaried_code
  ,x_contract_id
  ,x_collective_agreement_id
  ,x_cagr_id_flex_num
  ,x_cagr_grade_def_id
  ,x_establishment_id;

Line: 320


              + NVL(ceil(x_last_update_date + 1), 0)
              + NVL(ceil(x_creation_date + 1), 0)
              + NVL(ceil(x_assignment_id + 1), 0)
              + NVL(ceil(x_effective_start_date + 1), 0)
              + NVL(ceil(x_effective_end_date + 1), 0)
              + NVL(ceil(x_business_group_id + 1), 0)
              + NVL(ceil(x_recruiter_id + 1), 0)
              + NVL(ceil(x_grade_id + 1), 0)
              + NVL(ceil(x_position_id + 1), 0)
              + NVL(ceil(x_job_id + 1), 0)
              + NVL(ceil(x_assignment_status_type_id + 1), 0)
              + NVL(ceil(x_payroll_id + 1), 0)
              + NVL(ceil(x_location_id + 1), 0)
              + NVL(ceil(x_person_referred_by_id + 1), 0)
              + NVL(ceil(x_supervisor_id + 1), 0)
              + NVL(ceil(x_special_ceiling_step_id + 1), 0)
              + NVL(ceil(x_person_id + 1), 0)
              + NVL(ceil(x_recruitment_activity_id + 1), 0)
              + NVL(ceil(x_source_organization_id + 1), 0)
              + NVL(ceil(x_organization_id + 1), 0)
              + NVL(ceil(x_people_group_id + 1), 0)
              + NVL(ceil(x_soft_coding_keyflex_id + 1), 0)
              + NVL(ceil(x_pay_basis_id + 1), 0)
              + NVL(ceil(x_assignment_sequence + 1), 0)
              + NVL(ceil(x_assignment_type + 1), 0)
              + NVL(ceil(x_primary_flag + 1), 0)
              + NVL(ceil(x_application_id + 1), 0)
              + NVL(ceil(x_assignment_number + 1), 0)
              + NVL(ceil(x_change_reason + 1), 0)
              + NVL(ceil(x_comment_id + 1), 0)
              + NVL(ceil(x_date_probation_end + 1), 0)
              + NVL(ceil(x_default_code_comb_id + 1), 0)
              + NVL(ceil(x_employment_category + 1), 0)
              + NVL(ceil(x_frequency + 1), 0)
              + NVL(ceil(x_internal_address_line + 1), 0)
              + NVL(ceil(x_manager_flag + 1), 0)
              + NVL(ceil(x_normal_hours + 1), 0)
              + NVL(ceil(x_perf_review_period + 1), 0)
              + NVL(ceil(x_perf_review_period_frequency + 1), 0)
              + NVL(ceil(x_period_of_service_id + 1), 0)
              + NVL(ceil(x_probation_period + 1), 0)
              + NVL(ceil(x_probation_unit + 1), 0)
              + NVL(ceil(x_sal_review_period + 1), 0)
              + NVL(ceil(x_sal_review_period_frequency + 1), 0)
              + NVL(ceil(x_set_of_books_id + 1), 0)
              + NVL(ceil(x_source_type + 1), 0)
              + NVL(ceil(x_time_normal_finish + 1), 0)
              + NVL(ceil(x_time_normal_start + 1), 0)
              + NVL(ceil(x_asg_request_id + 1), 0)
              + NVL(ceil(x_program_application_id + 1), 0)
              + NVL(ceil(x_program_id + 1), 0)
              + NVL(ceil(x_program_update_date + 1), 0)
              + NVL(ceil(x_asg_title + 1), 0)
              + NVL(ceil(x_object_version_number + 1), 0)
              + NVL(ceil(x_bargaining_unit_code + 1), 0)
              + NVL(ceil(x_labour_union_member_flag + 1), 0)
              + NVL(ceil(x_hourly_salaried_code + 1), 0)
              + NVL(ceil(x_contract_id + 1), 0)
              + NVL(ceil(x_collective_agreement_id + 1), 0)
              + NVL(ceil(x_cagr_id_flex_num + 1), 0)
              + NVL(ceil(x_cagr_grade_def_id + 1), 0)
              + NVL(ceil(x_establishment_id + 1), 0) ;