SELECT DISTINCT/* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ OHS.SUB_ORGANIZATION_LEVEL ID , OHS.SUB_ORGANIZATION_LEVEL VALUE , HR_GENERAL.START_OF_TIME DATE_FROM , HR_GENERAL.END_OF_TIME DATE_TO /*PARENT IDS*/ /*IF YOU USE THE BUSINESS GROUP FROM OSV IN X BG MODE YOU GET MANY BGS AND MANY LEVELS!*/ , HR_GENERAL.GET_BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM HRI_ORG_HRCHY_SUMMARY OHS , PER_ORG_STRUCTURE_VERSIONS OSV WHERE OHS.ORG_STRUCTURE_VERSION_ID = OSV.ORG_STRUCTURE_VERSION_ID /*RESTRICTIONS*/ /*SECURITY*/ AND OSV.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID , OSV.BUSINESS_GROUP_ID) WITH READ ONLY