How to get the compensation plan id and option id using SQL Query

Go to Tools a Reports and Analytics a Click on Browse Catalog a Click on New a Select Data Model a click on + icon a select SQL Query a enter any name a select ApplicationDB_HCM a write the query in the SQL Query box a click on OK a go to Data tab a select the Rows as 200 a click on View a click on Table View
 
select * from cmp_components_vl

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.