APPS.PA_PAXCPCAL_XMLP_PKG SQL Statements

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

Line: 26

      SELECT
        SUBSTR(MEANING,4,14)
      INTO NDF
      FROM
        PA_LOOKUPS
      WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
        AND LOOKUP_TYPE = 'MESSAGE';

Line: 35

    /*    SELECT
          CP_DPIS_THROUGH
        INTO PA_DPIS_THRU_DATE
        FROM
          DUAL;

Line: 40

        SELECT
          P_CONC_REQUEST_ID
        INTO P_CONC_REQUEST_ID
        FROM
          DUAL; */

Line: 75

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

Line: 95

    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;