VIEW: APPS.PER_ALL_WORKFORCE_V

Source

View Text - Preformatted

SELECT PER.PERSON_ID , PER.FULL_NAME , PER.ORDER_NAME , decode (nvl(PER.CURRENT_EMPLOYEE_FLAG,'N'),'Y',PER.EMPLOYEE_NUMBER,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 PER.CURRENT_EMPLOYEE_FLAG = 'Y' OR ( 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
, DECODE (NVL(PER.CURRENT_EMPLOYEE_FLAG
, 'N')
, 'Y'
, PER.EMPLOYEE_NUMBER
, 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 PER.CURRENT_EMPLOYEE_FLAG = 'Y' OR ( NVL(FND_PROFILE.VALUE('HR_TREAT_CWK_AS_EMP')
, 'N')='Y'
AND PER.CURRENT_NPW_FLAG = 'Y' )