APPS.HRI_OLTP_PMV_UTIL_SNPSHT SQL Statements

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

Line: 13

  SELECT 1
  FROM hri_cl_per_snrmgr_ct
  WHERE id = p_supervisor_id
  AND p_effective_date BETWEEN start_date AND end_date;

Line: 41

  SELECT 1
  FROM hri_cal_snpsht_wrkfc
  WHERE snapshot_date = p_effective_date;

Line: 72

  SELECT 1
  FROM hri_cal_snpsht_wcnt_chg
  WHERE snapshot_date = p_effective_date;