APPS.CE_CEXAVBCH_XMLP_PKG SQL Statements

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

Line: 14

        SELECT
          A.BANK_ACCOUNT_NAME,
          A.BANK_ACCOUNT_NUM,
          B.BANK_NAME,
          B.BANK_BRANCH_NAME,
          A.CURRENCY_CODE,
          L.MEANING,
          L2.MEANING,
          A.BANK_ACCOUNT_TYPE
        INTO
          C_BANK_ACCOUNT_NAME
          ,C_BANK_ACCOUNT_NUM
          ,C_BANK_NAME
          ,C_BANK_BRANCH_NAME
          ,C_BANK_CURRENCY_CODE
          ,C_TRANSACTION_TYPE
          ,C_RECEIPT_TRANSLATION
          ,C_BANK_ACCOUNT_TYPE
        FROM
          CE_LOOKUPS L,
          CE_LOOKUPS L2,
          CE_BANK_BRANCHES_V B,
          CE_BANK_ACCTS_GT_V A
        WHERE L.LOOKUP_TYPE = 'BATCH_TYPE'
          AND L.LOOKUP_CODE = P_TYPE
          AND L2.LOOKUP_TYPE = 'TRX_TYPE'
          AND L2.LOOKUP_CODE = 'CASH'
          AND B.BRANCH_PARTY_ID = A.BANK_BRANCH_ID
          AND A.BANK_ACCOUNT_ID = P_BANK_ACCOUNT;

Line: 94

        SELECT
          SUM(NVL(AMOUNT
                 ,0)),
          SUM(NVL(BANK_ACCOUNT_AMOUNT
                 ,0))
        INTO
          C_BATCH_AMOUNT
          ,C_BATCH_BANK_ACCOUNT_AMOUNT
        FROM
          CE_200_TRANSACTIONS_V A
        WHERE TRX_TYPE in ( 'PAYMENT' , 'REFUND' )
          AND BATCH_ID = BATCH_ID_1
          AND NVL(STATUS
           ,'NEGOTIABLE') <> 'VOIDED';

Line: 114

        SELECT
          SUM(NVL(A.AMOUNT
                 ,0)),
          SUM(NVL(A.BANK_ACCOUNT_AMOUNT
                 ,0))
        INTO
          C_BATCH_AMOUNT
          ,C_BATCH_BANK_ACCOUNT_AMOUNT
        FROM
          CE_222_TRANSACTIONS_V A
        WHERE A.TRX_TYPE IN ( 'MISC' , 'CASH' )
          AND A.BATCH_ID = BATCH_ID_1;

Line: 140

        SELECT
          SUM(NVL(AMOUNT
                 ,0)),
          ROUND(SUM(NVL(BANK_ACCOUNT_AMOUNT
                       ,0))
               ,C_PRECISION)
        INTO
          C_BATCH_AMOUNT
          ,C_BATCH_BANK_ACCOUNT_AMOUNT
        FROM
          CE_200_TRANSACTIONS_V
        WHERE TRX_TYPE in ( 'PAYMENT' , 'REFUND' )
          AND BATCH_ID = BATCH_ID_1
          AND NVL(STATUS
           ,'NEGOTIABLE') <> 'VOIDED';

Line: 161

        SELECT
          SUM(NVL(A.AMOUNT
                 ,0)),
          ROUND(SUM(NVL(A.BANK_ACCOUNT_AMOUNT
                       ,0))
               ,C_PRECISION)
        INTO
          C_BATCH_AMOUNT
          ,C_BATCH_BANK_ACCOUNT_AMOUNT
        FROM
          CE_222_TRANSACTIONS_V A
        WHERE A.TRX_TYPE IN ( 'MISC' , 'CASH' )
          AND A.BATCH_ID = BATCH_ID_1;

Line: 188

        SELECT
          SUM(NVL(AMOUNT
                 ,0)),
          SUM(NVL(BANK_ACCOUNT_AMOUNT
                 ,0))
        INTO
          C_BATCH_AMOUNT
          ,C_BATCH_BANK_ACCOUNT_AMOUNT
        FROM
          CE_200_TRANSACTIONS_V
        WHERE TRX_TYPE in ( 'PAYMENT' , 'REFUND' )
          AND BATCH_ID = BATCH_ID_1
          AND NVL(STATUS
           ,'NEGOTIABLE') <> 'VOIDED';

Line: 208

        SELECT
          SUM(NVL(A.AMOUNT
                 ,0)),
          SUM(NVL(A.BANK_ACCOUNT_AMOUNT
                 ,0))
        INTO
          C_BATCH_AMOUNT
          ,C_BATCH_BANK_ACCOUNT_AMOUNT
        FROM
          CE_222_TRANSACTIONS_V A
        WHERE A.TRX_TYPE IN ( 'MISC' , 'CASH' )
          AND A.BATCH_ID = BATCH_ID_1;