View: HR_ATH_EMPGROUP_V

Product:	PER - Human Resources
Description:	View to support Authoria Integration
Implementation/DBA Data:	APPS.HR_ATH_EMPGROUP_V

View Text

SELECT TO_CHAR(O.ORGANIZATION_ID) EMPLOYEE_GROUPID
, O.NAME NAME
, O.DATE_FROM START_DATE
, NVL(O.DATE_TO
, TO_DATE('12/31/4712'
, 'MM/DD/YYYY')) END_DATE
FROM HR_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O3
WHERE O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O3.ORG_INFORMATION_CONTEXT ||'' = 'CLASS'
AND O3.ORG_INFORMATION1 = 'HR_ORG'
AND O3.ORG_INFORMATION2 = 'Y'
AND O.INTERNAL_EXTERNAL_FLAG = 'INT'

Columns