View: HR_EMPLOYERS_V

Product:	PER - Human Resources
Description:	HR_EMPLOYERS_V lists the organizations which have been identified as Employers.
Implementation/DBA Data:	APPS.HR_EMPLOYERS_V

View Text

SELECT OU1.ORGANIZATION_ID
, OU1.BUSINESS_GROUP_ID
, OU1.NAME
, OU1.DATE_FROM
, OU1.DATE_TO
, OU1.INTERNAL_ADDRESS_LINE
, OU1.LOCATION_ID
, OU1.COMMENTS
, OI1.ORG_INFORMATION2
FROM HR_ORGANIZATION_INFORMATION OI1
, HR_ALL_ORGANIZATION_UNITS OU1
WHERE OU1.ORGANIZATION_ID = OI1.ORGANIZATION_ID
AND OI1.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND OI1.ORG_INFORMATION1 = 'EMPLOYER'
AND OI1.ORG_INFORMATION2 = 'Y'

Columns