Get Ledger ID using a profile

Use the below query to get the ledger id for an org:-


select (select ledger_id from gl_ledgers where name=  mo_utils.Get_Ledger_Name( fnd_profile.value('ORG_ID') )) AS l_ledger_id from dual;