959: -- Fix bug#6654759 add start
960: --Get LE Name
961: SELECT XEP.name
962: INTO l_le_name
963: FROM XLE_ENTITY_PROFILES XEP
964: WHERE XEP.LEGAL_ENTITY_ID = l_le_id;
965: -- Fix bug#6654759 add end
966:
967: /*FND_FILE.put_line(FND_FILE.output, '
1665: AND HAOTL.LANGUAGE = USERENV('LANG')
1666: ;*/
1667: SELECT XEP.name --Updated to fix the issue that no legal entity name was found based on current legal entity id
1668: INTO l_le_name
1669: FROM XLE_ENTITY_PROFILES XEP
1670: WHERE XEP.LEGAL_ENTITY_ID = l_le_id
1671: ;
1672:
1673: /*FND_FILE.put_line(FND_FILE.output, '