How to find Legal Entity name in Oracle apps

SELECT   XEP.NAME
  INTO   LEGAL_ENTITY_NAME
  FROM   XLE_ENTITY_PROFILES XEP
 WHERE   LEGAL_ENTITY_ID  =  (SELECT   DISTINCT DEFAULT_LEGAL_CONTEXT_ID
                               FROM   HR_OPERATING_UNITS
                              WHERE   NAME = 'XX_OPERATING_UNIT')

How to find Application Instance Login URL same database

---Application Instance Login URL

SELECT profile_option_value URL

  FROM fnd_profile_option_values

 WHERE     profile_option_id =

              (SELECT profile_option_id

                 FROM fnd_profile_options

                WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT')

       AND level_value = 0;