How to find out Apps Instance Login URL from database

Just login to your apps database for DEV/UAT/PROD and run the following query to see corresponding Apps Login URL

SELECT home_url FROM icx_parameters;