Query to get Grade Name in Fusion HCM

SELECT PGFT.NAME
          FROM FUSION.PER_ALL_PEOPLE_F      PAPF,
           FUSION.PER_ALL_ASSIGNMENTS_M PAAM,
           FUSION.PER_GRADES_F_TL       PGFT
     WHERE 1 = 1
       AND PAPF.PERSON_ID = PAAM.PERSON_ID
       AND PAAM.GRADE_ID = PGFT.GRADE_ID
       AND PGFT.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 PGFT.EFFECTIVE_START_DATE AND
           PGFT.EFFECTIVE_END_DATE;

Comments

Popular posts from this blog

Query to get Salary Change details in Fusion HCM

Oracle Fusion HCM - Enhancements to Summary of Changes and History Sections in Redwood Workforce Structures Pages

๐Ÿงพ Streamlining Payroll Operations with Oracle Payroll Activity Center