APPS.CE_CEXINERR_XMLP_PKG SQL Statements

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

Line: 11

        SELECT
          L.MEANING
        INTO C_ALL_TRANSLATION
        FROM
          GL_SETS_OF_BOOKS SOB,
          CE_SYSTEM_PARAMETERS SP,
          CE_LOOKUPS L
        WHERE SOB.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID
          AND L.LOOKUP_TYPE = 'LITERAL'
          AND L.LOOKUP_CODE = 'ALL'
          AND ROWNUM = 1;

Line: 32

          SELECT
            ABB.BANK_NAME,
            ABB.BANK_BRANCH_NAME
          INTO C_BANK_NAME_DSP,C_BANK_BRANCH_NAME_DSP
          FROM
            CE_BANK_BRANCHES_V ABB
          WHERE ABB.BRANCH_PARTY_ID = P_BANK_BRANCH_ID;

Line: 49

            SELECT
              ABA.BANK_ACCOUNT_NUM,
              ABA.BANK_ACCOUNT_NAME,
              ABA.CURRENCY_CODE
            INTO C_BANK_ACCOUNT_NUM_DSP,C_BANK_ACCOUNT_NAME_DSP,C_BANK_CURRENCY_CODE_DSP
            FROM
              CE_BANK_ACCTS_GT_V ABA
            WHERE ABA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID
              AND ABA.ACCOUNT_CLASSIFICATION = 'INTERNAL';

Line: 120

    select fnd_global.nls_date_format into C_DATEFORMAT from dual;