VIEW: APPS.HRI_CL_PER_SUP_HX_V

Source

View Text - Preformatted

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 (per.current_employee_flag = 'Y' OR per.current_npw_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' OR peo2.current_npw_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

View Text - HTML Formatted

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 (PER.CURRENT_EMPLOYEE_FLAG = 'Y' OR PER.CURRENT_NPW_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' OR PEO2.CURRENT_NPW_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