BIP – Query to check if employee bank account is active or not

ByMandeep Gupta

BIP – Query to check if employee bank account is active or not

select ext_bank_account_id
,case when nvl(end_date,trunc(sysdate)) >= trunc(sysdate)
 then 'Active'
 else 'Inactive'
end active_inactive
from IBY_EXT_BANK_ACCOUNTS

About the author

Mandeep Gupta administrator