APPS.HRI_OPL_SETUP_DIAGNOSTIC SQL Statements

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

Line: 172

  SELECT
   stp.object_name
  FROM
   hri_adm_dgnstc_setup   stp
  ,hri_adm_dgnstc_sbscrb  sbs
  WHERE stp.object_type= p_object_type
  AND stp.object_name = sbs.object_name
  AND stp.object_type = sbs.object_type
  AND sbs.functional_area_cd = p_functional_area
  AND (p_object_name IS NULL OR stp.object_name = p_object_name)
  AND stp.enabled_flag='Y'
  AND ((stp.foundation_hr_flag = 'Y' AND
        hri_bpl_system.is_full_hr_installed = 'N')
    OR hri_bpl_system.is_full_hr_installed = 'Y')
  ORDER BY 1;

Line: 190

  SELECT stp.object_name
  FROM
   hri_adm_dgnstc_setup  stp
  WHERE stp.object_type= p_object_type
  AND (p_object_name IS NULL OR stp.object_name = p_object_name)
  AND stp.enabled_flag='Y'
  AND ((stp.foundation_hr_flag = 'Y' AND
        hri_bpl_system.is_full_hr_installed = 'N')
    OR hri_bpl_system.is_full_hr_installed = 'Y')
  ORDER BY 1;