VIEW: APPS.PER_ALL_WORKFORCE_V

Source

View Text - Preformatted

SELECT per.person_id, per.full_name, per.order_name, per.employee_number worker_number, per.employee_number, per.applicant_number, per.npw_number, per.current_employee_flag, per.current_npw_flag, per.effective_start_date, per.effective_end_date, per.business_group_id, per.global_name, per.local_name, hr_person_name.get_list_name(per.global_name ,per.local_name) list_name FROM per_all_people_f per WHERE per.current_employee_flag = 'Y' UNION ALL SELECT per.person_id, per.full_name, per.order_name, per.npw_number worker_number, per.employee_number, per.applicant_number, per.npw_number, per.current_employee_flag, per.current_npw_flag, per.effective_start_date, per.effective_end_date, per.business_group_id, per.global_name, per.local_name, hr_person_name.get_list_name(per.global_name ,per.local_name) list_name FROM per_all_people_f per WHERE nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' AND per.current_npw_flag = 'Y'

View Text - HTML Formatted

SELECT PER.PERSON_ID
, PER.FULL_NAME
, PER.ORDER_NAME
, PER.EMPLOYEE_NUMBER WORKER_NUMBER
, PER.EMPLOYEE_NUMBER
, PER.APPLICANT_NUMBER
, PER.NPW_NUMBER
, PER.CURRENT_EMPLOYEE_FLAG
, PER.CURRENT_NPW_FLAG
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID
, PER.GLOBAL_NAME
, PER.LOCAL_NAME
, HR_PERSON_NAME.GET_LIST_NAME(PER.GLOBAL_NAME
, PER.LOCAL_NAME) LIST_NAME
FROM PER_ALL_PEOPLE_F PER
WHERE PER.CURRENT_EMPLOYEE_FLAG = 'Y' UNION ALL SELECT PER.PERSON_ID
, PER.FULL_NAME
, PER.ORDER_NAME
, PER.NPW_NUMBER WORKER_NUMBER
, PER.EMPLOYEE_NUMBER
, PER.APPLICANT_NUMBER
, PER.NPW_NUMBER
, PER.CURRENT_EMPLOYEE_FLAG
, PER.CURRENT_NPW_FLAG
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID
, PER.GLOBAL_NAME
, PER.LOCAL_NAME
, HR_PERSON_NAME.GET_LIST_NAME(PER.GLOBAL_NAME
, PER.LOCAL_NAME) LIST_NAME
FROM PER_ALL_PEOPLE_F PER
WHERE NVL(FND_PROFILE.VALUE('HR_TREAT_CWK_AS_EMP')
, 'N') = 'Y'
AND PER.CURRENT_NPW_FLAG = 'Y'