APPS.CE_CEZBAERR_XMLP_PKG SQL Statements

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

Line: 36

        SELECT
          L.MEANING
        INTO
          C_ALL_TRANSLATION
        FROM
          CE_LOOKUPS L
        WHERE L.LOOKUP_TYPE = 'LITERAL'
          AND L.LOOKUP_CODE = 'ALL';

Line: 58

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

            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';