29: ,C_TRANSACTION_TYPE
30: ,C_RECEIPT_TRANSLATION
31: ,C_BANK_ACCOUNT_TYPE
32: FROM
33: CE_LOOKUPS L,
34: CE_LOOKUPS L2,
35: CE_BANK_BRANCHES_V B,
36: CE_BANK_ACCTS_GT_V A
37: WHERE L.LOOKUP_TYPE = 'TRAN_ORG_TYPE'
30: ,C_RECEIPT_TRANSLATION
31: ,C_BANK_ACCOUNT_TYPE
32: FROM
33: CE_LOOKUPS L,
34: CE_LOOKUPS L2,
35: CE_BANK_BRANCHES_V B,
36: CE_BANK_ACCTS_GT_V A
37: WHERE L.LOOKUP_TYPE = 'TRAN_ORG_TYPE'
38: AND L.LOOKUP_CODE = P_TYPE