SELECT O.ORGANIZATION_ID , O.NAME , O.BUSINESS_GROUP_ID , O.DATE_FROM , O.DATE_TO FROM HR_ORGANIZATION_UNITS O WHERE O.ORGANIZATION_ID IN ( SELECT SE.ORGANIZATION_ID_CHILD FROM PER_ORG_STRUCTURE_ELEMENTS SE WHERE SE.ORG_STRUCTURE_VERSION_ID = (SELECT TO_NUMBER(INFO.ORG_INFORMATION2) FROM HR_ORGANIZATION_INFORMATION INFO WHERE INFO.ORG_INFORMATION_CONTEXT||'' = 'PROJECT BURDENING HIERARCHY' AND INFO.ORGANIZATION_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID') ) UNION ALL SELECT PA_UTILS.GET_ORG_HIERARCHY_TOP(TO_NUMBER(INFO.ORG_INFORMATION2)) FROM HR_ORGANIZATION_INFORMATION INFO WHERE INFO.ORG_INFORMATION_CONTEXT||'' = 'PROJECT BURDENING HIERARCHY' AND INFO.ORGANIZATION_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))