SELECT DISTINCT/* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ SHS.SUPV_LEVEL ID , SHS.SUPV_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_SUPV_HRCHY_SUMMARY SHS WHERE /*RESTRICTIONS*/ /*SECURITY*/ SHS.SUPV_BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID , SHS.SUPV_BUSINESS_GROUP_ID) WITH READ ONLY