Absence query to fetch plan use details with entitlements

Summary:

I am looking for help in developing a sql query to fetch the absence details for a person for the below attached highlighted information.

I need the tables used and fields which need to be joined to fetch the details

Content (required):

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

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