SQL query to retrieve additional manager types at the employee level

Summary:

Content (please ensure you mask any confidential information):

Hello experts,

we need to retrieve hierarchies loaded in core hr for additional manager types (not LINE_MANAGER type) at the employee level (PROJECT_MANAGER).

Do you have a sample SQL query to retrieve this information at the employee level? In other words we need the PROJECT_MANAGER person number loaded at the employee level.

Thanks in advance for your help!

Regards,

Valerio

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

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