Person Habits in Oracle HCM Cloud Benefits

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
Person and Assignment in Oracle HCM Cloud

You can use the below SQL Query to retrieve Person and Assignment Information from Oracle HCM Cloud.