How to fetch the list of candidates having job offer at 'Pending Manual Processing' state

Summary:

We need a SQL Query to fetch the list of candidates having job offer at 'Pending Manual Processing' state for any position

Please advise

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):