Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM Cloud

Summary:

Query to get Employee Bank Account Details not tagged to personal payment method in Oracle HCM Cloud

Content (required):

Hi All,

We got the requirement to extract the employee details whose bank account details are not tagged to any personal payment method.

Could you assist on the query part?

I tried with the below query, but its not giving the correct output.

select h.party_id, per.person_number,eba.*

from per_persons p

, hz_parties h

, hz_orig_sys_references hosp

, per_all_people_f per

, iby_ext_bank_accounts eba

, iby_account_owners ao

where hosp.owner_table_id = h.party_id