Query to get grade ladder in Fusion HCM

SELECT PGLFT.NAME

        FROM FUSION.PER_PERSON_NAMES_F     PPNF,

             FUSION.PER_ALL_ASSIGNMENTS_M  PAAM,

             FUSION.PER_GRADE_LADDERS_F_TL PGLFT,

             FUSION.PER_GRADE_LADDERS_F    PGLF

       WHERE PPNF.PERSON_ID = PAAM.PERSON_ID

         AND PAAM.GRADE_LADDER_PGM_ID(+) = PGLFT.GRADE_LADDER_ID

         AND PPNF.PERSON_ID = PAAM.PERSON_ID

         AND PPNF.NAME_TYPE = 'GLOBAL'

         AND PAAM.ASSIGNMENT_TYPE = 'E'

         AND PAAM.PERSON_ID = P_PERSON_ID

         AND PGLFT.LANGUAGE = USERENV('LANG')

         AND PGLFT.GRADE_LADDER_ID = PGLF.GRADE_LADDER_ID

         AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND

             PPNF.EFFECTIVE_END_DATE

         AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND

             PAAM.EFFECTIVE_END_DATE

         AND TRUNC(SYSDATE) BETWEEN PGLFT.EFFECTIVE_START_DATE AND

             PGLFT.EFFECTIVE_END_DATE

         AND TRUNC(SYSDATE) BETWEEN PGLF.EFFECTIVE_START_DATE AND

             PGLF.EFFECTIVE_END_DATE;