SQL to validate bank load in Fusion

SQL to validate bank load
-------------------------------

SELECT
  bankparty.party_id bank_id
, bankparty.party_name bank_name
, bankorgprofile.home_country bank_home_country
, TO_CHAR(bankorgprofile.effective_start_date,'DD-MON-YYYY') bank_start_date
, TO_CHAR(bankorgprofile.effective_end_date,'DD-MON-YYYY') bank_end_date
, bankorgprofile.bank_or_branch_number bank_number
FROM
  hz_parties bankparty
, hz_organization_profiles bankorgprofile
, hz_code_assignments BankCA
WHERE
  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 bankorgprofile.party_id = BankParty.PARTY_ID
AND bankparty.party_type = 'ORGANIZATION'
AND trunc(SYSDATE) BETWEEN TRUNC(bankorgprofile.effective_start_date) AND NVL(TRUNC(bankorgprofile.effective_end_date),trunc(SYSDATE) + 1)