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