SQL Code to Extract Setup Grade Rates with Grade Name — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

SQL Code to Extract Setup Grade Rates with Grade Name

edited Dec 31, 2020 11:15AM in Reporting and Analytics for HCM 3 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!