SELECT MGR.SUP_ABSOLUTE_LEVEL , MGR.SUB_ABSOLUTE_LEVEL , MGR.SUB_RELATIVE_LEVEL , MGR.SUP_PERSON_ID , MGR.SUB_PERSON_ID , MGR.SUP_ASSIGNMENT_ID , MGR.SUB_ASSIGNMENT_ID , SUP.FULL_NAME , SUB.FULL_NAME , MGR.EFFECTIVE_START_DATE , MGR.EFFECTIVE_END_DATE FROM HRI_CS_SUPH_V MGR , PER_ALL_PEOPLE_F SUP , PER_ALL_PEOPLE_F SUB WHERE MGR.PRIMARY_HIERARCHY_FLAG_CODE = 'Y' AND MGR.SUP_PERSON_ID = SUP.PERSON_ID AND MGR.SUB_PERSON_ID = SUB.PERSON_ID AND MGR.EFFECTIVE_START_DATE BETWEEN SUP.EFFECTIVE_START_DATE AND SUP.EFFECTIVE_END_DATE AND MGR.EFFECTIVE_START_DATE BETWEEN SUB.EFFECTIVE_START_DATE AND SUB.EFFECTIVE_END_DATE