Query retrieving manager job name

Summary:

Content (please ensure you mask any confidential information):

Hello experts,

how can I retrieve the line manager job name? I've used the following query but the job name is the employee job instead of the manager one. How can I adjust the following query? The PASF.MANAGER_ID instead is properly retrieved. The issue is for PJF.NAME which extracts the employee job name.

Kind Regards,

Valerio

SELECT PJF.NAME as MANAGER_JOB, PASF.MANAGER_ID as MANAGER_ID
FROM PER_ALL_ASSIGNMENTS_M ASG, PER_JOBS_F_TL PJF,PER_ASSIGNMENT_SUPERVISORS_F PASF
WHERE
ASG.ASSIGNMENT_TYPE IN ('C','E','T','N')