Need a SQL query to get the value for Parent Position for the employee's Assignment Position.

Summary

Need a SQL query to get the value for Parent Position for the employee's Assignment Position.

Content

Need a SQL query to get the value for Parent Position for the employee's Assignment Position.

 

This is in the below page.

Go to  Setup and Maintenance > 

                                     select search task from tasks menu on right side.

search for Manage Positions.

Search for a Position .

we need to get the details of Parent Position under Position Description section.

 

Screenshot of the Position page is attached. Parent Position field is indicated with an arrow shape.

 

Thanks,

JP