DBA Data[Home] [Help]

APPS.PA_PAUBRUER_XMLP_PKG SQL Statements

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

Line: 34

      SELECT
        MEANING
      INTO L_NO_DATA_FOUND
      FROM
        PA_LOOKUPS
      WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
        AND LOOKUP_TYPE = 'MESSAGE';
Line: 79

        SELECT
          MEANING
        INTO L_NO_DATA_FOUND
        FROM
          PA_LOOKUPS
        WHERE LOOKUP_CODE = 'NO_DATA_FOUND'
          AND LOOKUP_TYPE = 'MESSAGE';
Line: 107

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