Query to get Organization name in Fusion HCM

SELECT HOUFT.NAME     
      FROM FUSION.HR_ORGANIZATION_UNITS_F_TL HOUFT
     WHERE HOUFT.ORGANIZATION_ID = &P_ORG_ID
       AND HOUFT.LANGUAGE = USERENV('LANG')
       AND TRUNC(SYSDATE) BETWEEN HOUFT.EFFECTIVE_START_DATE AND
           HOUFT.EFFECTIVE_END_DATE;

Comments