SELECT ORG.ORGANIZATION_ID ID , ORG.NAME VALUE , ORG.DATE_FROM START_DATE , NVL(ORG.DATE_TO , HR_GENERAL.END_OF_TIME) END_DATE , FND_GLOBAL.RESP_ID RESPONSIBILITY_ID , ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM HR_ORGANIZATION_UNITS ORG , HR_ORGANIZATION_INFORMATION INF WHERE ORG.ORGANIZATION_ID = INF.ORGANIZATION_ID AND INF.ORG_INFORMATION1 = 'HR_ORG' UNION ALL SELECT -1 ID , '' VALUE , HR_GENERAL.START_OF_TIME START_DATE , HR_GENERAL.END_OF_TIME END_DATE , FND_GLOBAL.RESP_ID RESPONSIBILITY_ID , -1 BUSINESS_GROUP_ID FROM DUAL WITH READ ONLY