VIEW: APPS.HRI_CL_PER_USER_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_from , 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 FROM per_people_x per , fnd_user usr WHERE usr.employee_id = per.person_id AND usr.user_id = fnd_global.user_id AND per.current_employee_flag = 'Y' 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_FROM
, 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
FROM PER_PEOPLE_X PER
, FND_USER USR
WHERE USR.EMPLOYEE_ID = PER.PERSON_ID
AND USR.USER_ID = FND_GLOBAL.USER_ID
AND PER.CURRENT_EMPLOYEE_FLAG = 'Y' WITH READ ONLY