SELECT OTL.ORGANIZATION_ID , OTL.NAME FROM HR_ALL_ORGANIZATION_UNITS_TL OTL , HR_ORGANIZATION_INFORMATION O2 WHERE OTL.ORGANIZATION_ID = O2.ORGANIZATION_ID AND O2.ORG_INFORMATION_CONTEXT = 'CLASS' AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT' AND O2.ORG_INFORMATION2 = 'Y' AND OTL.LANGUAGE = USERENV( 'LANG' )
SELECT OTL.ORGANIZATION_ID
, OTL.NAME
FROM HR_ALL_ORGANIZATION_UNITS_TL OTL
, HR_ORGANIZATION_INFORMATION O2
WHERE OTL.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O2.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT'
AND O2.ORG_INFORMATION2 = 'Y'
AND OTL.LANGUAGE = USERENV( 'LANG' )
|
|
|