View: PAY_TAX_UNITS_LOV

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_TAX_UNITS_LOV

View Text

SELECT HOU.ROW_ID
, HOU.ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID + 0
, HOUTL.NAME
, HOI2.ORG_INFORMATION1 FEDERAL_ID
FROM HR_ORGANIZATION_INFORMATION HOI2
, HR_ORGANIZATION_INFORMATION HOI1
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL
, HR_ORGANIZATION_UNITS HOU
WHERE HOU.ORGANIZATION_ID = HOUTL.ORGANIZATION_ID
AND HOUTL.LANGUAGE = USERENV('LANG')
AND HOI1.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND HOI1.ORG_INFORMATION1 = 'HR_LEGAL'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND HOI2.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND HOI2.ORG_INFORMATION_CONTEXT || '' = 'EMPLOYER IDENTIFICATION'

Columns