SELECT PEO.VALUE , ASG.EMP_ID , ASG.MGR_ID FROM HRI_DBI_CL_PER_N_V PEO , FII_CC_MGR_HIERARCHIES ASG WHERE ASG.EMP_ID = PEO.ID AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE AND PEO.EFFECTIVE_END_DATE AND (MGR_LEVEL = EMP_LEVEL OR MGR_LEVEL = EMP_LEVEL-1)