How to get the list of customer bank accounts for which the primary bank accounts have got end date

Hi Team,

Could you please help to get the Open AR transaction which the Primary bank account got end dated.

I am using below query.

but it is giving all the open invoice.

Query:

SELECT

    rct.trx_number,

    rct.customer_trx_id,

    aps.status,

    rct.org_id,

    hao.name,

    hca.account_number "Customer Account Number",

    piu.start_date "Bank Account Use Start Date",

    piu.end_date "Bank Account Use End Date",  -- Bank Account End Date

    eba.bank_account_num "Bank Account Number",

    eba.bank_account_name "Bank Account Name",

    eba.start_date "Bank Account Start Date",

    eba.end_date "Bank Account End Date",