Query to find the Job Grades in HRMS

SELECT NULL “ValidGradeId”,
TO_CHAR(pvg.date_from,’YYYY/MM/DD’) “EffectiveStartDate”,
TO_CHAR(pvg.date_to,’YYYY/MM/DD’) “EffectiveEndDate”,
NULL “GradeId”,
pg.grade_id “GradeCode”,
‘COMMON’ “SetCode”,
pj.job_id “JobCode”,
NULL “JobId”,
NULL “GUID”,
(SELECT name
FROM v$database) “SourceSystemOwner”,
pvg.valid_grade_id “SourceSystemId”,
NULL “GradeSetCode”
FROM per_valid_grades pvg,
per_jobs pj,
per_grades pg
WHERE pj.business_group_id = fnd_profile.value(‘PER_BUSINESS_GROUP_ID’)
AND pj.business_group_id = pvg.business_group_id
AND pj.business_group_id = pg.business_group_id
AND pvg.grade_id = pg.grade_id
AND pvg.job_id = pj.job_id
AND pvg.job_id IS NOT NULL;