Query to fetch cash management -bank account details, accounting period and GL segment values

Summary:

I need a query to fetch cash management 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 .

Below is the sample query I developed but it returned no data. I am not sure if this query is correct.

SELECT
cba.BANK_ACCOUNT_ID,
cba.BANK_ACCOUNT_NAME,
cba.BANK_ACCOUNT_NAME_ALT,
cba.BANK_ACCOUNT_NUM,
GLC.SEGMENT1,
GLC.SEGMENT2,
GLP.PERIOD_NAME
FROM CE_BANK_ACCOUNTS CBA,
CE_BANK_ACCOUNT_CASH_CCIDS CCIDS,
GL_CODE_COMBINATIONS GLC,
GL_PERIOD_STATUSES GLP