View: HRI_CL_PER_SUP_HX_V

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

View Text

SELECT PER.PERSON_ID ID
, PER.FULL_NAME VALUE
, PER.EFFECTIVE_START_DATE DATE_FROM
, PER.EFFECTIVE_END_DATE DATE_TO
, PER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PER.CURRENT_EMPLOYEE_FLAG CURRENT_EMPLOYEE_FLAG
, PER.CURRENT_APPLICANT_FLAG CURRENT_APPLICANT_FLAG
, PER.CURRENT_EMP_OR_APL_FLAG CURRENT_EMP_OR_APL_FLAG
, PER.PERSON_TYPE_ID PERSON_TYPE_ID
, PER.COMMENT_ID COMMENT_ID
FROM PER_PEOPLE_X PER
WHERE CURRENT_EMPLOYEE_FLAG = 'Y'
AND EXISTS ( SELECT -1
FROM PER_ASSIGNMENTS_X ASG
, PER_PEOPLE_X PEO2
WHERE PER.PERSON_ID = ASG.SUPERVISOR_ID
AND ASG.PERSON_ID = PEO2.PERSON_ID
AND PEO2.CURRENT_EMPLOYEE_FLAG = 'Y' ) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, -1 BUSINESS_GROUP_ID
, 'NA_EDW' CURRENT_EMPLOYEE_FLAG
, 'NA_EDW' CURRENT_APPLICANT_FLAG
, 'NA_EDW' CURRENT_EMP_OR_APL_FLAG
, -1 PERSON_TYPE_ID
, -1 COMMENT_ID
FROM DUAL WITH READ ONLY

Columns