View: HR_WORKSITE_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.HR_WORKSITE_V

View Text

SELECT HOI1.ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID
, HOI2.ORGANIZATION_ID
, HOI2.ORG_INFORMATION2
, HOI2.ORG_INFORMATION3
, HOI2.ORG_INFORMATION4
, HOI2.ORG_INFORMATION5
, HOI2.ORG_INFORMATION6
, HOI2.ORG_INFORMATION7
, HOI2.ORG_INFORMATION8
, HRL.ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2
, HRL.ADDRESS_LINE_3
, HRL.TOWN_OR_CITY
, DECODE(HRL.STYLE
, 'US'
, HRL.REGION_2
, 'CA'
, HRL.REGION_1
, '')
, HRL.POSTAL_CODE
FROM HR_ORGANIZATION_INFORMATION HOI1
, HR_ORGANIZATION_INFORMATION HOI2
, HR_LOCATIONS HRL
, HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_UNITS HOU2
WHERE HOI2.ORG_INFORMATION_CONTEXT = 'WORKSITE FILING'
AND HOI2.ORG_INFORMATION1 = 'Y'
AND SUBSTR(HOI1.ORG_INFORMATION2
, 1
, 10) = SUBSTR(HOI2.ORG_INFORMATION2
, 1
, 10)
AND HOI1.ORG_INFORMATION_CONTEXT = 'STATE TAX RULES'
AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
AND HRL.LOCATION_ID = HOU.LOCATION_ID
AND HOI1.ORG_INFORMATION1 = HRL.REGION_2
AND HOI1.ORGANIZATION_ID = HOU2.ORGANIZATION_ID
AND HOU.BUSINESS_GROUP_ID = HOU2.BUSINESS_GROUP_ID
AND EXISTS (SELECT NULL
FROM HR_ORGANIZATION_INFORMATION HOI
WHERE HOI.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND HOI.ORG_INFORMATION1 = 'HR_ESTAB'
AND ORG_INFORMATION2 = 'Y')
AND EXISTS (SELECT NULL
FROM HR_ORGANIZATION_INFORMATION HOI
WHERE HOI.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND HOI.ORG_INFORMATION1 = 'HR_LEGAL'
AND ORG_INFORMATION2 = 'Y')

Columns