APPS.PQH_PQHUSEPR_XMLP_PKG SQL Statements

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

Line: 48

      SELECT
        NAME
      FROM
        PER_JOBS_VL
      WHERE JOB_ID = JOB_ID
        AND BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
        AND sysdate between NVL(DATE_FROM
         ,SYSDATE)
        AND NVL(DATE_TO
         ,SYSDATE);

Line: 72

      SELECT
        MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_TYPE = 'PQH_ACADEMIC_RANK'
        AND LOOKUP_CODE = RANK_ID;

Line: 93

      SELECT
        MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_TYPE = 'PQH_TENURE_STATUS'
        AND LOOKUP_CODE = TENURE_STATUS_CD;

Line: 127

      SELECT
        LAST_NAME || ', ' || FIRST_NAME
      FROM
        PER_ALL_PEOPLE_F
      WHERE PERSON_ID = P_MANAGER_ID
        AND sysdate between EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE;