70: , CBA.BANK_ACCOUNT_TYPE ACCOUNT_TYPE
71: , CBA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
72: FROM
73: HZ_PARTIES HP
74: , HZ_ORGANIZATION_PROFILES HOP
75: , HZ_CODE_ASSIGNMENTS HCA -- added for fixing bug# 10268933
76: , CE_BANK_ACCOUNTS CBA
77: WHERE CBA.BANK_ID = HP.PARTY_ID(+)
78: AND CBA.BANK_ID = HOP.PARTY_ID(+)
89: --ONLY THE LATEST BANK PROFILE SHOULD BE EXPORTED
90: -- BUG 10110988, ONLY EXPORT THE LATEST BANK INFO
91: AND HOP.ORGANIZATION_PROFILE_ID = (
92: SELECT MAX(HOP2.ORGANIZATION_PROFILE_ID)
93: FROM HZ_ORGANIZATION_PROFILES HOP2
94: WHERE CBA.BANK_ID = HOP2.PARTY_ID
95: -- the following is commented for fixing bug# 10268933
96: /*AND EXTRACT(YEAR FROM HOP2.EFFECTIVE_START_DATE) <= PN_ACCOUNT_YEAR*/
97: AND ( HOP2.EFFECTIVE_END_DATE IS NULL