Query to extract Grade and Grade Steps Data

 SELECT DISTINCT
to_char(pgf.effective_start_Date,'DD/MM/YYYY') effective_start_Date,
to_char(pgf.effective_end_Date,'DD/MM/YYYY') effective_end_Date,
PG.ACTIVE_STATUS STATUS,
fs.set_code,
pg.GRADE_CODE,
pgf.name grade_name,
PGS.SEQUENCE step_number,
pgsf.name grade_step_name,
decode( pgs.sequence, (
select sequence
from PER_GRADE_STEPS_F pgsf
where pgsf.grade_step_id = pg.CEILING_STEP_ID
), 'Y','') CEILING_STEP
FROM PER_GRADES_F_TL PGF,
PER_RATE_VALUES_F prv,
PER_GRADES_F PG,
PER_GRADE_STEPS_F_TL PGSF,
PER_GRADE_STEPS_F PGS,
        HRC_INTEGRATION_KEY_MAP HRC,
fnd_setid_sets_vl fs 
WHERE  1=1
AND PG.grade_id = PGF.grade_id
AND PGS.grade_step_id = PRV.rate_object_id
AND PG.grade_id = PGS.grade_id
AND PGS.grade_step_id = PGSF.grade_step_id(+)
AND HRC.SURROGATE_ID = PGF.GRADE_ID
AND fs.set_id = pg.set_id
AND HRC.OBJECT_NAME LIKE 'Grade'
ORDER BY pg.GRADE_CODE