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;
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
Post a Comment