APPS.PQH_PQHEEO5_XMLP_PKG SQL Statements

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

Line: 48

    SELECT
      COUNT(1)
    INTO
      L_NO_OF_ANNEXES
    FROM
      (   SELECT
          ASS.LOCATION_ID
        FROM
          PER_ALL_ASSIGNMENTS_F ASS,
          HR_ORGANIZATION_UNITS_V HOU,
          PER_ALL_PEOPLE_F PEO
        WHERE ASS.ORGANIZATION_ID = HOU.ORGANIZATION_ID
          AND ASS.PERSON_ID = PEO.PERSON_ID
          AND CP_REPORT_DATE between ASS.EFFECTIVE_START_DATE
          AND ASS.EFFECTIVE_END_DATE
          AND CP_REPORT_DATE between PEO.EFFECTIVE_START_DATE
          AND PEO.EFFECTIVE_END_DATE
          AND HOU.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
        UNION
        SELECT
          LOCATION_ID
        FROM
          HR_ALL_ORGANIZATION_UNITS
        WHERE BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
          AND NVL(DATE_TO
           ,CP_REPORT_DATE + 1) >= CP_REPORT_DATE );

Line: 74

    SELECT
      COUNT(1)
    INTO
      L_NO_OF_SCHOOLS
    FROM
      HR_ORGANIZATION_UNITS_V HOU
    WHERE HOU.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;