A lot of times, we need to find to out the Person Habits for Benefits if an employee is tobacco user or not. You can use and change the SQL with your requirements
SQL to find all the potential and processed life events
You can use the below SQL Query to retrieve Person and Assignment Information from Oracle HCM Cloud.
Use this Query to fetch benefits data from Oracle Cloud / HCM Fusion.