View: HRI_CL_PER_RECMGR_HX_V

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.HRI_CL_PER_RECMGR_HX_V

View Text

SELECT PEO.PERSON_ID ID
, PEO.FULL_NAME VALUE
, PEO.EFFECTIVE_START_DATE START_DATE
, PEO.EFFECTIVE_END_DATE END_DATE
, PEO.PARTY_ID PARTY_ID
FROM PER_PEOPLE_F PEO
WHERE TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND EXISTS (SELECT NULL
FROM PER_ALL_VACANCIES VAC
WHERE VAC.RECRUITER_ID = PEO.PERSON_ID)
AND CURRENT_EMPLOYEE_FLAG = 'Y' UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -1 PARTY_ID
FROM DUAL WITH READ ONLY

Columns