SQL logic to pull the LE Name from the Department level

Summary:

My business requirement is to pull the LE name from the department page. I need to pull the Dep name, Dep Managers name and associated LE Name on the Department Page.

Content (please ensure you mask any confidential information):

I am able to add the LE name at the department level, but when I am checking in the backend legal_entity_id not getting stored in the backend.

I have checked the below table 'HR_ALL_ORGANIZATION_UNITS_F'

Could you please advise if you have the query available? If not, please let us know whether there are any alternative tables we can use. We would appreciate any insights or suggestions you can share.