VIEW: APPS.PER_WORKFORCE_V2

Source

View Text - Preformatted

SELECT DISTINCT PER.PERSON_ID , PER.FULL_NAME , PER.ORDER_NAME , NVL( PER.EMPLOYEE_NUMBER,PER.NPW_NUMBER) WORKER_NUMBER, PER.EMPLOYEE_NUMBER , PER.APPLICANT_NUMBER , PER.NPW_NUMBER, PER.EFFECTIVE_START_DATE , PER.EFFECTIVE_END_DATE , PER.BUSINESS_GROUP_ID , PER.CURRENT_APPLICANT_FLAG , PER.CURRENT_EMPLOYEE_FLAG, PER.CURRENT_NPW_FLAG FROM PER_ALL_PEOPLE_F PER , per_person_type_usages_f ptu, per_person_types pt, fnd_sessions fs WHERE DECODE(HR_SECURITY.VIEW_ALL , 'Y' , 'TRUE', HR_SECURITY.SHOW_PERSON (per.person_id, per.current_applicant_flag , per.current_employee_Flag, per.current_npw_flag , per.employee_number, per.applicant_number, per.npw_number)) = 'TRUE' AND decode(hr_general.get_xbg_profile, 'Y',per.business_group_id , hr_general.get_business_group_id) = per.business_group_id and ptu.person_id = per.person_id and pt.person_type_id = ptu.person_type_Id and pt.system_person_type IN ('EMP','EX_EMP','CWK','EX_CWK') and fs.effective_date between per.effective_start_Date and per.effective_end_date and fs.effective_date between ptu.effective_start_Date and ptu.effective_end_date and fs.session_id = USERENV('sessionid')

View Text - HTML Formatted

SELECT DISTINCT PER.PERSON_ID
, PER.FULL_NAME
, PER.ORDER_NAME
, NVL( PER.EMPLOYEE_NUMBER
, PER.NPW_NUMBER) WORKER_NUMBER
, PER.EMPLOYEE_NUMBER
, PER.APPLICANT_NUMBER
, PER.NPW_NUMBER
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.BUSINESS_GROUP_ID
, PER.CURRENT_APPLICANT_FLAG
, PER.CURRENT_EMPLOYEE_FLAG
, PER.CURRENT_NPW_FLAG
FROM PER_ALL_PEOPLE_F PER
, PER_PERSON_TYPE_USAGES_F PTU
, PER_PERSON_TYPES PT
, FND_SESSIONS FS
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_PERSON (PER.PERSON_ID
, PER.CURRENT_APPLICANT_FLAG
, PER.CURRENT_EMPLOYEE_FLAG
, PER.CURRENT_NPW_FLAG
, PER.EMPLOYEE_NUMBER
, PER.APPLICANT_NUMBER
, PER.NPW_NUMBER)) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, PER.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = PER.BUSINESS_GROUP_ID
AND PTU.PERSON_ID = PER.PERSON_ID
AND PT.PERSON_TYPE_ID = PTU.PERSON_TYPE_ID
AND PT.SYSTEM_PERSON_TYPE IN ('EMP'
, 'EX_EMP'
, 'CWK'
, 'EX_CWK')
AND FS.EFFECTIVE_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PTU.EFFECTIVE_START_DATE
AND PTU.EFFECTIVE_END_DATE
AND FS.SESSION_ID = USERENV('SESSIONID')