APPS.PA_PAXCPGAL_XMLP_PKG SQL Statements

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

Line: 24

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

Line: 34

      SELECT
        P_DPIS_THROUGH
      INTO PA_DPIS_THRU_DATE
      FROM
        DUAL;

Line: 39

      SELECT
        P_CONC_REQUEST_ID
      INTO P_CONC_REQUEST_ID
      FROM
        DUAL;

Line: 48

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

Line: 61

      SELECT
        P_PA_THROUGH_DATE
      INTO PA_THRU_DATE
      FROM
        DUAL;

Line: 66

      SELECT
        MAX(END_DATE)
      INTO PA_PERIOD_END_DATE
      FROM
        PA_PERIODS
      WHERE TRUNC(END_DATE) <= TRUNC(PA_THRU_DATE);

Line: 79

            SELECT
              CAPITAL_EVENT_NUMBER
            INTO P_CAPITAL_EVENT_NUMBER
            FROM
              PA_CAPITAL_EVENTS
            WHERE CAPITAL_EVENT_ID = P_CAPITAL_EVENT_ID
              AND ROWNUM = 1;

Line: 122

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

Line: 144

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

        DELETE FROM PA_CAPITAL_EXCEPTIONS
         WHERE REQUEST_ID = P_CONC_REQUEST_ID;

Line: 189

        DELETE FROM PA_REPORTING_EXCEPTIONS
         WHERE REQUEST_ID = P_CONC_REQUEST_ID
           AND ATTRIBUTE8 = 'PROJECT EVENT ERRORS';