SQL Code to Extract Setup Grade Rates with Grade Name

Summary

SQL Code to Extract Setup Grade Rates with Grade Name

Content

Team,

 

I have a similar requirement. 
I am trying to fetch the setup data of Grade Rates with Grade name. 

Navigation: 

My Client Group>Work Structure> Manage Grade Rates
I was working on the below query. However, I could not join the Grade Name in this query.  

Select PRFV.RATE_ID
, PRFV.EFFECTIVE_START_DATE
, PRFV.EFFECTIVE_END_DATE
, PRFV.LEGISLATION_CODE
, PRFV.RATE_TYPE
, PRFV.RATE_OBJECT_TYPE
, PRFV.RATE_UOM
, PRFV.RATE_FREQUENCY
, PRFV.ANNUALIZATION_FACTOR
, PRFV.CURRENCY_CODE
, PRFV.ACTIVE_STATUS
, PRVF.RATE_OBJECT_ID