Query to get the List of Grades and codes

SELECT PG.GRADE_CODE , PGT.NAME

FROM PER_GRADES_F_TL PGT, PER_GRADES_F PG

WHERE PGT.SOURCE_LANG = 'US'

AND PGT.GRADE_ID = PG.GRADE_ID

AND PG.ACTIVE_STATUS = 'A'

AND PG.GRADE_TYPE = 'GRADE'

AND TRUNC(SYSDATE) BETWEEN PG.EFFECTIVE_START_DATE AND PG.EFFECTIVE_END_DATE

ORDER BY PG.GRADE_CODE

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Posted by : Mohammad