SQL query to fetch the annual leave accural as of the given custom date parameter in the report

Summary:

I am working on an absence report where requirement is to fetch the balance of absence types as of the given custom date parameter. Can please someone guide me or provide me the sample query.

Thanks.

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