How do you write a query for standard working hours in BIP?

I need to get the standard working hours for employees into my query. I can see the standard working hours work is worked out in the following order :

'Standard Working Hours' is displayed on the worker Assignment based on the following hierarchy: Position -> Department -> Legal Employer -> Enterprise.

This makes it complicated on how to write this query in SQL for BIP.