Sql to get both linked requisition details (pipeline and standard) from the candidate application

Summary:

Need help on the query to find a candidate on a requisition is moved from a linked pipeline requisition.

Content (please ensure you mask any confidential information):

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

25B

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