SELECT SUBSTR(ORI.ORG_INFORMATION1 , 1 , 10) , ORG.NAME , ORG.ORGANIZATION_ID , ORI.ORG_INFORMATION2 , ORG.BUSINESS_GROUP_ID FROM HR_ORGANIZATION_UNITS ORG , HR_ORGANIZATION_INFORMATION ORI , FND_SESSIONS SES WHERE ORG.ORGANIZATION_ID = ORI.ORGANIZATION_ID AND ORI.ORG_INFORMATION_CONTEXT = 'DE_TAX_OFFICE_INFO' AND ORG.ORGANIZATION_ID IN (SELECT ORGANIZATION_ID FROM HR_ORGANIZATION_INFORMATION ORI WHERE ORI.ORG_INFORMATION_CONTEXT = 'CLASS' AND ORI.ORG_INFORMATION1 = 'DE_TAX_OFFICE' AND ORI.ORG_INFORMATION2 = 'Y') AND SES.SESSION_ID = USERENV('SESSIONID') AND ORG.DATE_FROM < = SES.EFFECTIVE_DATE AND ((ORG.DATE_TO IS NULL) OR (ORG.DATE_TO >= SES.EFFECTIVE_DATE))