APPS.HRI_OLTP_VIEW_WRKFRC SQL Statements

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

Line: 66

  SELECT
   fct.per_person_mgr_fk
  ,fct.mgr_mngrsc_fk
  ,fct.org_organztn_fk
  ,fct.job_job_fk
  ,fct.grd_grade_fk
  ,fct.pos_position_fk
  ,fct.geo_location_fk
  FROM hri_mds_wrkfc_mnth_ct  fct
  WHERE fct.asg_assgnmnt_fk = p_assignment_id
  AND fct.time_month_snp_fk = to_number(to_char(p_effective_date, 'YYYYQMM'));

Line: 219

  SELECT
   NVL(SUM(headcount_hire), 0)
  ,NVL(SUM(fte_hire), 0)
  FROM hri_mds_wrkfc_mnth_ct
  WHERE asg_assgnmnt_fk = p_assignment_id
  AND time_month_snp_fk BETWEEN to_number(to_char(p_effective_start_date, 'YYYYQMM'))
                        AND to_number(to_char(p_effective_end_date, 'YYYYQMM'));

Line: 253

  SELECT
   NVL(SUM(headcount_prmtn), 0)
  ,NVL(SUM(fte_prmtn), 0)
  FROM hri_mds_wrkfc_mnth_ct
  WHERE asg_assgnmnt_fk = p_assignment_id
  AND time_month_snp_fk BETWEEN to_number(to_char(p_effective_start_date, 'YYYYQMM'))
                        AND to_number(to_char(p_effective_end_date, 'YYYYQMM'));