APPS.CE_CEXSTMRR_XMLP_PKG SQL Statements

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

Line: 16

        SELECT
          L.MEANING,
          L2.MEANING
        INTO
          C_ALL_TRANSLATION
          ,C_EXTERNAL_TRANSLATION
        FROM
          CE_LOOKUPS L,
          CE_LOOKUPS L2
        WHERE L.LOOKUP_TYPE = 'LITERAL'
          AND L.LOOKUP_CODE = 'ALL'
          AND L2.LOOKUP_TYPE = 'STATEMENT_LINE_STATUS'
          AND L2.LOOKUP_CODE = 'EXTERNAL';

Line: 39

          SELECT
            ABB.BANK_NAME,
            ABB.BANK_BRANCH_NAME,
            ABA.BANK_ACCOUNT_NAME,
            ABA.BANK_ACCOUNT_NUM,
            ABA.CURRENCY_CODE
          INTO
            C_BANK_NAME_DSP
            ,C_BANK_BRANCH_DSP
            ,C_ACCOUNT_NAME_DSP
            ,C_ACCOUNT_NUMBER_DSP
            ,C_BANK_CURR_DSP
          FROM
            CE_BANK_BRANCHES_V ABB,
            CE_BANK_ACCTS_GT_V ABA
          WHERE ABA.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID
            AND ABB.BRANCH_PARTY_ID = ABA.BANK_BRANCH_ID;

Line: 112

      SELECT
        SUM(SL.AMOUNT)
      INTO
        AMOUNT
      FROM
        CE_STATEMENT_LINES SL
      WHERE SL.STATEMENT_HEADER_ID = C_STAT_HEADER_ID1
        AND exists (
        SELECT
          DISTINCT
          ART.STATEMENT_LINE_ID
        FROM
          CE_RECONCILED_TRANSACTIONS_V ART
        WHERE ART.STATEMENT_LINE_ID = SL.STATEMENT_LINE_ID );

Line: 140

      SELECT
        SUM(SL.AMOUNT)
      INTO
        AMOUNT
      FROM
        CE_STATEMENT_LINES SL
      WHERE SL.STATEMENT_HEADER_ID = C_STAT_HEADER_ID1
        AND SL.STATUS = 'ERROR'
        AND ( SL.TRX_TYPE = 'CREDIT'
      OR SL.TRX_TYPE = 'MISC_CREDIT'
      OR SL.TRX_TYPE = 'SWEEP_IN' );

Line: 165

      SELECT
        SUM(SL.AMOUNT)
      INTO
        AMOUNT
      FROM
        CE_STATEMENT_LINES SL
      WHERE SL.STATEMENT_HEADER_ID = C_STAT_HEADER_ID1
        AND SL.STATUS = 'ERROR'
        AND SL.TRX_TYPE in ( 'DEBIT' , 'MISC_DEBIT' , 'NSF' , 'REJECTED' , 'SWEEP_OUT' );