How to get shift name start time, end time for certain date, from the work schedule caledar

Summary:

In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed

Emp number

Date

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