To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submitted

Summary:

To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted

Content (required):

We are looking SQL query/OTBI report to pull Open enrollment employee data if life event closed and Enrollment not yet submitted.

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

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