Fusion Queries for Bank Name and Nationality

Bank Query:

Select distinct bank_name from pay_bank_accounts

 

Nationality:

select lookup_code,meaning from hr_lookups where lookup_type like 'NATIONALITY' and enabled_flag = 'Y'