Query to get Grade Step in Fusion HCM

select PGSFL.Name
      FROM FUSION.PER_ALL_PEOPLE_F         PAPF,
           FUSION.PER_PERSON_NAMES_F       PPNF,
           FUSION.PER_ALL_ASSIGNMENTS_M    PAAM,
           FUSION.PER_GRADES_F             PGF,
           FUSION.PER_GRADE_STEPS_F_TL     PGSFL,
           FUSION.Per_Assign_Grade_Steps_f  PAGSF
     where paam.assignment_status_type = 'ACTIVE'
       AND PAAM.PRIMARY_FLAG = 'Y'
       AND PGSFL.LANGUAGE = USERENV('LANG')
       AND PPNF.NAME_TYPE = 'GLOBAL'
       AND PAAM.PERSON_ID = PAPF.PERSON_ID
       AND PAAM.GRADE_ID = PGF.GRADE_ID
       AND PPNF.PERSON_ID = PAAM.PERSON_ID
       AND PAPF.PERSON_NUMBER = P_PERSON_NUMBER
       AND PAGSF.ASSIGNMENT_ID = PAAM.ASSIGNMENT_ID
       AND PAGSF.GRADE_STEP_ID = PGSFL.GRADE_STEP_ID
       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 PPNF.EFFECTIVE_START_DATE AND
           PPNF.EFFECTIVE_END_DATE
       AND TRUNC(sysdate) BETWEEN PGF.EFFECTIVE_START_DATE AND
           PGF.EFFECTIVE_END_DATE
       AND TRUNC(sysdate) BETWEEN PAGSF.EFFECTIVE_START_DATE AND
           PAGSF.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