APPS.CE_CEXAVTRX_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 = 'TRAN_ORG_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;