Oracle Application's URL from back end

option 1

SELECT home_url
   FROM icx_parameters

option 2


Select PROFILE_OPTION_VALUE
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;