View: HRI_CL_PER_HIRMGR_HX_V

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRI_CL_PER_HIRMGR_HX_V

View Text

SELECT PEO.PERSON_ID ID
, PEO.FULL_NAME VALUE
, PEO.EFFECTIVE_START_DATE DATE_FROM
, PEO.EFFECTIVE_END_DATE DATE_TO
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_PEOPLE_X PEO
WHERE PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
AND EXISTS (SELECT NULL
FROM PER_ALL_VACANCIES VAC
WHERE VAC.MANAGER_ID = PEO.PERSON_ID) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, -1 BUSINESS_GROUP_ID
FROM DUAL

Columns