VIEW: APPS.PA_OPERATING_UNITS_V

Source

View Text - Preformatted

SELECT hr.organization_id org_id ,hr.name operating_unit FROM hr_operating_units hr WHERE mo_global.check_access(hr.organization_id) = 'Y' and exists (select '1' from pa_implementations_all imp where Imp.org_id = hr.organization_id )

View Text - HTML Formatted

SELECT HR.ORGANIZATION_ID ORG_ID
, HR.NAME OPERATING_UNIT
FROM HR_OPERATING_UNITS HR
WHERE MO_GLOBAL.CHECK_ACCESS(HR.ORGANIZATION_ID) = 'Y'
AND EXISTS (SELECT '1'
FROM PA_IMPLEMENTATIONS_ALL IMP
WHERE IMP.ORG_ID = HR.ORGANIZATION_ID )