Peoplesoft Bank Account PYE_BANKACCT table Report

select A.EMPLID,A.ACCOUNT_ID,A.ACCOUNT_NAME,A.EFF_STATUS,A.ACCOUNT_TYPE_PYE,A.COUNTRY_CD,A.BANK_CD,A.BRANCH_EC_CD,A.ACCOUNT_EC_ID,CHECK_DIGIT,
A.CURRENCY_CD,A.IAT_IND,A.ACCOUNT_NAME_AC from sysadm.PS_PYE_BANKACCT A WHERE A.EMPLID IN
(SELECT DISTINCT B.EMPLID FROM SYSADM.PS_JOB B WHERE B.REG_REGION = 'TWN') ORDER BY 1;