Query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groups

GaryRMLC

Can someone please help with a Oracle Fusion SQL query to find pay period and Hours Worked, separating out PTO vs ESL vs FMLA hour groups.

I found the attached as a start but am only finding the element names of Regular Pay and Regular Pay Earnings data.
Maybe our system doesn't have anyone with PTO hours in the subset we have loaded thus far or is it somehow being excluded in the qualifications.

We are very new to HCM SQL Queries and are really struggling!

Thanks!

SampleHours.sql

GaryRMLC

P.s. I started with the query from this post.

https://community.oracle.com/products/oracleanalytics/discussion/25751/i-need-a-sql-query-to-pull-hours-and-wages-by-day-paid