tcc export candidates requisition

Summary: I would like to export candidates on posted requisitions where no candidates are in the offer step or beyond. I know there is at least one subquery that is needed. I just cannot wrap my head around how to write the TCC script.

Content (please ensure you mask any confidential information):

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

21A

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