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):