Query to find the requisition id for internal candidates

Summary:

How to find through -which requisition internal Candidate has assignment change?
we have employees who have assignment changes because of the assignment change (like Transfer,manager change) from Assignment screen and also we have employee's that have assignment change because of hiring for an internal requisition (from recruiting).

Auditors want to see if an assignment is changed because of which requisition id.

Content (please ensure you mask any confidential information):

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

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