View: PER_WORKFORCE_V2

Product:	PER - Human Resources
Description:	Date effective view
Implementation/DBA Data:	APPS.PER_WORKFORCE_V2

View Text

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')

Columns