I need a query to get bank account details along with accounting period and segment

Summary:

Content (please ensure you mask any confidential information):

I need a query to fetch bank account details like bank account name , bank account number along with accounting period, legal entity segment and account segment values using cash management table in oracle fusion .

I could fetch some data through ce_bank_statements but could not find out the accounting period , legal entity segment and account segment values ..
Below is the query I developed but it returned no data. I am not sure if this is correct.

SELECT
cba.BANK_ACCOUNT_ID,
cba.BANK_ACCOUNT_NAME,
cba.BANK_ACCOUNT_NAME_ALT,