SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ ORG.ORGANIZATION_ID ID , ORG.NAME VALUE , ORG.DATE_FROM DATE_FROM , NVL(ORG.DATE_TO , HR_GENERAL.END_OF_TIME) DATE_TO /*PARENT IDS*/ , ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM HR_ORGANIZATION_UNITS ORG , HR_ORGANIZATION_INFORMATION INF WHERE ORG.ORGANIZATION_ID = INF.ORGANIZATION_ID /*RESTRICTIONS*/ AND INF.ORG_INFORMATION1 = 'HR_ORG' AND TRUNC(SYSDATE) BETWEEN ORG.DATE_FROM AND NVL(ORG.DATE_TO , HR_GENERAL.END_OF_TIME) AND EXISTS /*VERIFY ORGANIZATION IS IN A CURRENT HIERARCHY*/ (SELECT -1 FROM HRI_ORG_HRCHY_SUMMARY OHS , PER_ORG_STRUCTURE_VERSIONS OSV WHERE ORG.ORGANIZATION_ID = OHS.SUB_ORGANIZATION_ID AND OHS.ORG_STRUCTURE_VERSION_ID = OSV.ORG_STRUCTURE_VERSION_ID AND TRUNC(SYSDATE) BETWEEN OSV.DATE_FROM AND NVL(OSV.DATE_TO , HR_GENERAL.END_OF_TIME) ) /*SECURITY*/ AND ORG.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID , ORG.BUSINESS_GROUP_ID) WITH READ ONLY