Need a query for absence eligibility profiles and eligibility criteria

Summary:

I need a query to fetch the list of absence eligibility profiles which have "Assignment Status" as one of the eligibility criteria.

Content (please ensure you mask any confidential information):

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

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