APPS.CE_CEXSTMSR_XMLP_PKG SQL Statements

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

Line: 16

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

Line: 34

          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_NAME_DSP
            ,C_BANK_ACCOUNT_NAME_DSP
            ,C_BANK_ACCOUNT_NUM_DSP
            ,C_BANK_CURRENCY_CODE_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: 71

      SELECT
        MEANING
      INTO
        C_BALANCES_BY
      FROM
        CE_LOOKUPS
      WHERE LOOKUP_TYPE = 'BALANCES_BY'
        AND LOOKUP_CODE = P_BALANCES_BY;

Line: 120

      SELECT
        count(*)
      INTO
        ITEMS
      FROM
        CE_STATEMENT_LINES
      WHERE STATEMENT_HEADER_ID = C_STAT_HEADER_ID;

Line: 141

      SELECT
        count(*)
      INTO
        ITEMS
      FROM
        CE_STATEMENT_LINES
      WHERE STATEMENT_HEADER_ID = C_STAT_HEADER_ID
        AND STATUS = 'UNRECONCILED';

Line: 164

      SELECT
        SUM(AMOUNT)
      INTO
        AMOUNT
      FROM
        CE_STATEMENT_LINES
      WHERE STATEMENT_HEADER_ID = C_STAT_HEADER_ID;

Line: 171

      SELECT
        SUM(AMOUNT_CLEARED)
      INTO
        AMOUNT_CLEARED
      FROM
        CE_RECONCILED_TRANSACTIONS_V
      WHERE STATEMENT_HEADER_ID = C_STAT_HEADER_ID;