APPS.CE_CEXCSHTR_XMLP_PKG SQL Statements

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

Line: 12

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

          SELECT
            L.LOOKUP_CODE,
            L.MEANING
          INTO
            C_ORDER_BY
            ,C_ORDER_BY_MEANING
          FROM
            CE_LOOKUPS L
          WHERE L.LOOKUP_TYPE = 'ABR_REPORT_SORT_BY'
            AND L.LOOKUP_CODE = P_SORT_BY;

Line: 57

          SELECT
            BB.BANK_NAME,
            BB.BANK_BRANCH_NAME,
            B.BANK_ACCOUNT_NAME,
            B.BANK_ACCOUNT_NUM,
            B.CURRENCY_CODE
          INTO
            C_BANK_NAME_DSP
            ,C_BANK_BRANCH_NAME_DSP
            ,C_BANK_ACCOUNT_NAME_DSP
            ,C_BANK_ACCOUNT_NUM_DSP
            ,C_BANK_CURRENCY_CODE_DSP
          FROM
            CE_BANK_BRANCHES_V BB,
            CE_BANK_ACCTS_GT_V B
          WHERE B.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID
            AND BB.BRANCH_PARTY_ID = B.BANK_BRANCH_ID;