Require query to get the offer and requisition number for a employee

Summary:

Require query to get the offer and requisition number for a employee

Content (required):

A person applied for multiple requisition, and he get offer on more than one requisition. and one offer converted to employment. Need a query to identify on which requisition he is finally converted to employee.

Thanks in advance.

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

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