APPS.PA_PAXPCPRS_XMLP_PKG SQL Statements

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

Line: 28

        SELECT
          SUBSTR(NAME
                ,1
                ,60)
        INTO PROJECT_ORG
        FROM
          HR_ORGANIZATION_UNITS
        WHERE ORGANIZATION_ID = PROJECT_ORGANIZATION;

Line: 39

        SELECT
          SEGMENT1
        INTO PROJ_NUMBER
        FROM
          PA_PROJECTS
        WHERE PROJECT_ID = PROJ;

Line: 48

        SELECT
          FULL_NAME
        INTO MANAGER_NAME
        FROM
          PER_PEOPLE_F
        WHERE PERSON_ID = PROJECT_MANAGER
          AND sysdate between EFFECTIVE_START_DATE
          AND NVL(EFFECTIVE_END_DATE
           ,SYSDATE + 1)
          AND ( CURRENT_NPW_FLAG = 'Y'
        OR CURRENT_EMPLOYEE_FLAG = 'Y' )
          AND DECODE(CURRENT_NPW_FLAG
              ,'Y'
              ,NPW_NUMBER
              ,EMPLOYEE_NUMBER) IS NOT NULL;

Line: 66

        SELECT
          SUBSTR(MEANING
                ,1
                ,40)
        INTO YES_NO_MEANING
        FROM
          FND_LOOKUPS
        WHERE LOOKUP_TYPE = 'YES_NO'
          AND LOOKUP_CODE = INCLUDE_CLOSED_PROJECTS;

Line: 92

    SELECT
      GL.NAME
    INTO L_NAME
    FROM
      GL_SETS_OF_BOOKS GL,
      PA_IMPLEMENTATIONS PI
    WHERE GL.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID;

Line: 108

    SELECT
      trim(replace(MEANING,'*',''))
    INTO MESSAGE_NAME
    FROM
      PA_LOOKUPS
    WHERE LOOKUP_TYPE = 'MESSAGE'
      AND LOOKUP_CODE = 'NO_DATA_FOUND';