Search This Blog

Thursday, June 1, 2017

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'