VIEW: APPS.HRI_CL_PER_EMP_H_V

Source

View Text - Preformatted

SELECT per.person_id ID , per.full_name VALUE , per.effective_start_date start_date , per.effective_end_date end_date , per.effective_start_date effective_start_date , per.effective_end_date effective_end_date , 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_f per WHERE per.current_employee_flag = 'Y' AND per.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, per.business_group_id) UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , hr_general.start_of_time effective_start_date , hr_general.end_of_time effective_end_date , -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 START_DATE
, PER.EFFECTIVE_END_DATE END_DATE
, PER.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, 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_F PER
WHERE PER.CURRENT_EMPLOYEE_FLAG = 'Y'
AND PER.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PER.BUSINESS_GROUP_ID) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, HR_GENERAL.START_OF_TIME EFFECTIVE_START_DATE
, HR_GENERAL.END_OF_TIME EFFECTIVE_END_DATE
, -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