Fast Formula to extract Manager ID (Person Number)

Summary

any ideas?

Content

Hello,

In my extract I have assignment ID. How to calculate Manager ID (Person Number)?

Currently we have this value set, but is not working. 

PER_ASSIGNMENT_SUPERVISORS_F MH, PER_ALL_PEOPLE_F PEF, PER_ALL_ASSIGNMENTS_M MA

PEF.PERSON_ID = MH.MANAGER_ID
                          AND MA.PERSON_ID = MH.PERSON_ID
                          AND MA.ASSIGNMENT_TYPE IN ('E','C','P')
                          AND MA.PRIMARY_FLAG = 'Y' 
                          AND EXISTS
                              (SELECT 1 
                              FROM
                              PER_ASSIGNMENT_SUPERVISORS_F PASF
                              WHERE MA.PERSON_ID = PASF.MANAGER_ID)
                          AND TRUNC(SYSDATE) BETWEEN MH.EFFECTIVE_START_DATE AND MH.EFFECTIVE_END_DATE 
                                                  AND TRUNC(SYSDATE) BETWEEN MA.EFFECTIVE_START_DATE AND MA.EFFECTIVE_END_DATE