APPS.PA_PAXEXADJ_XMLP_PKG SQL Statements

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

Line: 33

      SELECT
        SEGMENT1
      INTO P_PROJECT_NUMBER
      FROM
        PA_PROJECTS
      WHERE PROJECT_ID = C_PROJECT_ID;

Line: 41

        SELECT
          TASK_NUMBER
        INTO P_TASK_NUMBER
        FROM
          PA_TASKS
        WHERE TASK_ID = C_TASK_ID;

Line: 50

        SELECT
          FULL_NAME
        INTO P_EMPLOYEE_NAME
        FROM
          PER_PEOPLE_F
        WHERE PERSON_ID = C_PERSON_ID
          AND sysdate between EFFECTIVE_START_DATE
          AND NVL(EFFECTIVE_END_DATE
           ,SYSDATE + 1)
          AND ( EMPLOYEE_NUMBER is not null
        OR NPW_NUMBER is not null );

Line: 78

    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: 95

    SELECT
      MEANING
    INTO MESSAGE_NAME
    FROM
      PA_LOOKUPS
    WHERE LOOKUP_TYPE = 'MESSAGE'
      AND LOOKUP_CODE = 'NO_DATA_FOUND';