Query to get Job Name in Fusion HCM

SELECT PJFT.NAME
      FROM FUSION.PER_ALL_PEOPLE_F      PAPF,
           FUSION.PER_ALL_ASSIGNMENTS_M PAAM,
           FUSION.PER_JOBS_F_TL         PJFT
     WHERE 1 = 1
       AND PAPF.PERSON_ID = PAAM.PERSON_ID
       AND PAAM.JOB_ID = PJFT.JOB_ID
       AND PJFT.LANGUAGE = USERENV('LANG')
       AND PAAM.ASSIGNMENT_TYPE = 'E'
       AND PAAM.Assignment_Status_Type = 'ACTIVE'
       AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER
       AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND
           PAPF.EFFECTIVE_END_DATE
       AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND
           PAAM.EFFECTIVE_END_DATE
       AND TRUNC(SYSDATE) BETWEEN PJFT.EFFECTIVE_START_DATE AND
           PJFT.EFFECTIVE_END_DATE;