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 for Oracle Cloud HCM   Begin Now

How to fetch the promotion details from CMP_CWB_PROMOTIONS for a particular plan cycle

in Compensation 2 comments

Summary:

How to fetch the promotion details from CMP_CWB_PROMOTIONS for a particular plan cycle

Content (please ensure you mask any confidential information):

we are trying to fetch the promotion details from CMP_CWB_PROMOTIONS for a particular plan cycle. But this table is containing only Promotion Id and no plan cycle related columns. Also, the table CMP_CWB_PERSON_INFO doesn't have promotion id. So, which table should be connected with CMP_CWB_PROMOTIONS to get promotion details for a particular plan and plan cycle. Any help on this would be much appreciated.

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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