922: -- Fix bug#6654759 add start
923: --Get LE Name
924: SELECT XEP.name
925: INTO l_le_name
926: FROM XLE_ENTITY_PROFILES XEP
927: WHERE XEP.LEGAL_ENTITY_ID = l_le_id;
928: -- Fix bug#6654759 add end
929:
930: /*FND_FILE.put_line(FND_FILE.output, '
1628: AND HAOTL.LANGUAGE = USERENV('LANG')
1629: ;*/
1630: SELECT XEP.name --Updated to fix the issue that no legal entity name was found based on current legal entity id
1631: INTO l_le_name
1632: FROM XLE_ENTITY_PROFILES XEP
1633: WHERE XEP.LEGAL_ENTITY_ID = l_le_id
1634: ;
1635:
1636: /*FND_FILE.put_line(FND_FILE.output, '