SQL query to retrieve compensation plan status at the employee level

Summary:

Content (please ensure you mask any confidential information):

Hello experts,

I need to track for all employees the status of their line managers compensation plans ("Submitted"; "In Approvals).

Is there a SQL query retrieving it?

Kind Regards,

Valerio

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

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