View: HR_ORGANIZATION_UNITS

Product:	PER - Human Resources
Description:	Secure view based on the corresponding _ALL_ table.
Implementation/DBA Data:	APPS.HR_ORGANIZATION_UNITS

View Text

SELECT
FROM HR_ALL_ORGANIZATION_UNITS HAO
, HR_ALL_ORGANIZATION_UNITS_TL HAOTL
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HAOTL.ORGANIZATION_ID))='TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, HAO.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = HAO.BUSINESS_GROUP_ID
AND HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID
AND HAOTL.LANGUAGE = USERENV('LANG')