APPS.PQH_PQHUSASR_XMLP_PKG SQL Statements

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

Line: 23

      SELECT
        TO_CHAR(MIN(PE.DATE_START)
               ,'DD-MON-YYYY')
      FROM
        PER_ALL_ASSIGNMENTS_F PAF,
        PER_EVENTS PE,
        HR_LOOKUPS HR,
        PER_ALL_PEOPLE_F PAP
      WHERE PE.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
        AND PAP.PERSON_ID = PAF.PERSON_ID
        AND PE.TYPE = HR.LOOKUP_CODE
        AND SYSDATE BETWEEN PAF.EFFECTIVE_START_DATE
        AND PAF.EFFECTIVE_END_DATE
        AND SYSDATE BETWEEN PAP.EFFECTIVE_START_DATE
        AND PAP.EFFECTIVE_END_DATE
        AND PE.EMP_OR_APL = 'E'
        AND HR.LOOKUP_TYPE = 'EMP_INTERVIEW_TYPE'
        AND PE.EVENT_OR_INTERVIEW = 'I'
        AND PE.DATE_START BETWEEN SYSDATE
        AND ADD_MONTHS(SYSDATE
                ,12)
        AND PAP.PERSON_ID = P_PERSON_ID
        AND PE.BUSINESS_GROUP_ID + 0 = P_BUSINESS_GROUP_ID;