Oracle EBS: Derive the Legal Entity Details given the Organization with type LE

Hi,

We are trying to derive the legal_entity_id given the organization_id where type is 'LE'.

Is there a way to connect this without using the name column?

We need to derive the legal entity of the organization defined in HR (not the default legal entity of the OU where organization belongs)

SELECT * FROM HR_ALL_ORGANIZATION_UNITS

where type = 'LE'

and name = 'Sample LE'

SELECT * FROM XLE_ENTITY_PROFILES

where name = 'Sample LE'

from above query is there a specific table where we can get the association between them?

Appreciate any help,Thanks,

Jd