APPS.PA_PACCINTG_XMLP_PKG SQL Statements

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

Line: 49

      SELECT
        SEGMENT1
      INTO P_FROM_PROJ_NUM
      FROM
        PA_PROJECTS_ALL
      WHERE PROJECT_ID = P_FROM_PROJECT_ID;

Line: 57

      SELECT
        SEGMENT1
      INTO P_TO_PROJ_NUM
      FROM
        PA_PROJECTS_ALL
      WHERE PROJECT_ID = P_TO_PROJECT_ID;

Line: 65

      SELECT
        END_DATE
      INTO P_EXP_ITEM_DATE
      FROM
        PA_IMPLEMENTATIONS PIMP,
        GL_PERIOD_STATUSES GLS
      WHERE PIMP.SET_OF_BOOKS_ID = GLS.SET_OF_BOOKS_ID
        AND GLS.APPLICATION_ID = 101
        AND GLS.PERIOD_NAME = P_RUN_PERIOD;

Line: 131

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

      SELECT
        PURGEABLE_FLAG
      INTO L_PURGEABLE_FLAG
      FROM
        PA_TRANSACTION_SOURCES
      WHERE TRANSACTION_SOURCE = 'Capitalized Interest';

Line: 184

          DELETE FROM PA_TRANSACTION_INTERFACE
           WHERE TRANSACTION_SOURCE = 'Capitalized Interest'
             AND BATCH_NAME = TO_CHAR(P_RUN_ID);

Line: 188

        DELETE FROM PA_TRANSACTION_XFACE_CONTROL
         WHERE TRANSACTION_SOURCE = 'Capitalized Interest'
           AND BATCH_NAME = TO_CHAR(P_RUN_ID);

Line: 198

        UPDATE
          PA_ALLOC_RUNS_ALL
        SET
          RELEASE_REQUEST_ID = NULL
        WHERE RUN_ID = P_RUN_ID;