Query : Get Bank Information from HZ Tables

select * from 
hz_parties bankparty, hz_code_assignments bankca
where 
bankparty.party_type = 'ORGANIZATION'

AND bankca.class_category = 'BANK_INSTITUTION_TYPE'
AND bankca.class_code IN ('BANK', 'CLEARINGHOUSE')
AND bankca.owner_table_name = 'HZ_PARTIES'
AND bankca.owner_table_id = bankparty.party_id
AND NVL (bankca.status, 'A') = 'A'