Business Unit ID query

 select BU.name, BU.organization_id BU_ID from hr_all_organization_units_vl BU,
HR_ORG_UNIT_CLASSIFICATIONS_F cl
where 1=1
and BU.organization_id=cl.organization_id
and CLASSIFICATION_CODE = 'FUN_BUSINESS_UNIT' 
and BU.name ='BU_NAME'