SQL to get individual compensation plan items to show under Additional compensation — 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

SQL to get individual compensation plan items to show under Additional compensation

Summary:

I want fetch Additional Compensation details for Individual Compensation plan through SQL. below is the screen I want to query. Person will have multiple plan and options and for them percentage also . Which table holds these values? I checked on these tables

cmp_plans_tl , cmp_plan_attributes, cmp_attribute_elements

But not able to figure out the link with employee , can anyone help me with these please.



Content (please ensure you mask any confidential information):


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



Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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