SELECT o3.org_information3,o3.attribute3
INTO l_org_information3，l_company_desc
FROM hr_all_organization_units o,
hr_all_organization_units_tl otl,
hr_organization_information o2,
hr_organization_information o3
WHERE o.organization_id = o2.organization_id
AND o.organization_id = o3.organization_id
AND o2.org_information_context || '' = 'CLASS'
AND o3.org_information_context = 'Operating Unit Information'
AND o2.org_information1 = 'OPERATING_UNIT'
AND o2.org_information2 = 'Y'
AND o.organization_id = otl.organization_id
AND otl.language = USERENV('LANG')
AND o.organization_id = &p_org_id;--OU id
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10359218/viewspace-749050/ ，如需转载，请注明出处，否则将追究法律责任。
