APPS.HRI_OLTP_PMV_UTIL_PKG SQL Statements

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

Line: 18

 (SELECT /*+ NO_UNNEST INDEX(sup hri_cs_suph_n4) */ null
  FROM  hri_cs_suph sup
  WHERE sup.sup_person_id IN (hri_bpl_security.get_apps_signin_person_id,&BIS_SELECTED_TOP_MANAGER)
  AND sup.sub_person_id = &HRI_PERSON+HRI_PER_USRDR_H
  AND sup.sub_invalid_flag_code = ''N''
  AND &BIS_CURRENT_ASOF_DATE BETWEEN sup.effective_start_date
              AND sup.effective_end_date)';

Line: 170

  	SELECT count(*) INTO l_hr_dir_chk
    FROM per_empdir_people
    WHERE orig_system = 'PER'
    AND rownum <= 1;