DBA Data[Home] [Help]

APPS.CE_CEXTRXCD_XMLP_PKG SQL Statements

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

Line: 22

          SELECT
            MEANING,
            MEANING,
            MEANING,
            MEANING,
            MEANING
          INTO
            C_BANK_ACCOUNT_NAME
            ,C_BANK_ACCOUNT_NUM
            ,C_BANK_NAME
            ,C_BANK_BRANCH_NAME
            ,C_BANK_CURRENCY_CODE
          FROM
            CE_LOOKUPS
          WHERE LOOKUP_TYPE = 'LITERAL'
            AND LOOKUP_CODE = 'ALL';
Line: 39

          SELECT
            A.BANK_ACCOUNT_NAME,
            A.BANK_ACCOUNT_NUM,
            B.BANK_NAME,
            B.BANK_BRANCH_NAME,
            A.CURRENCY_CODE
          INTO
            C_BANK_ACCOUNT_NAME
            ,C_BANK_ACCOUNT_NUM
            ,C_BANK_NAME
            ,C_BANK_BRANCH_NAME
            ,C_BANK_CURRENCY_CODE
          FROM
            CE_BANK_BRANCHES_V B,
            CE_BANK_ACCTS_GT_V A
          WHERE B.BRANCH_PARTY_ID = A.BANK_BRANCH_ID
            AND A.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID;