SQL Query to Extract Loaded Banks and Bank Branches

select cba.bank_name,

       cba.bank_number,
   cba.home_country_code,
       cbb.bank_branch_name,
       cbb.branch_number,
   cbb.EFT_SWIFT_CODE,
   cbb.EFT_USER_NUMBER,
   cbb.RFC_CODE RFC,
   to_char(cba.start_date,'DD-MON-YYYY')start_date,
   to_char(cba.end_date,'DD-MON-YYYY')end_date,
   hrc.object_name,
   hrc.source_system_owner,
   hrc.source_system_id
from ce_index_banks cba,
     ce_index_bank_branches cbb,
hrc_integration_key_map hrc
where 1=1
and cba.bank_party_id=cbb.bank_party_id
and hrc.surrogate_id = cbb.BRANCH_PARTY_ID

and hrc.source_system_owner = 'HRC_SQLLDR'