SELECT TO_CHAR(O.ORGANIZATION_ID) EMPLOYEE_GROUPID , O.NAME NAME , O.DATE_FROM START_DATE , NVL(O.DATE_TO , TO_DATE('12/31/4712' , 'MM/DD/YYYY')) END_DATE FROM HR_ORGANIZATION_UNITS O , HR_ORGANIZATION_INFORMATION O3 WHERE O.ORGANIZATION_ID = O3.ORGANIZATION_ID AND O3.ORG_INFORMATION_CONTEXT ||'' = 'CLASS' AND O3.ORG_INFORMATION1 = 'HR_ORG' AND O3.ORG_INFORMATION2 = 'Y' AND O.INTERNAL_EXTERNAL_FLAG = 'INT'