View: PA_EMPLOYEES_RES_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_EMPLOYEES_RES_V

View Text

SELECT PERSON_ID
, SUBSTR(FULL_NAME
, 1
, 60)
, EMPLOYEE_NUMBER
, 'Y'
, 'HOURS'
, 'N'
, LK.MEANING
FROM PA_EMPLOYEES P
, PA_LOOKUPS LK
WHERE ((PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES = 'Y' ) OR EXISTS (SELECT 'ACTIVE ASSIGNMENT AS OF SYSDATE'
FROM PER_ASSIGNMENTS_F A
, PER_ASSIGNMENT_STATUS_TYPES AST
WHERE A.PERSON_ID = P.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE
AND A.PRIMARY_FLAG = 'Y'
AND A.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND AST.ASSIGNMENT_STATUS_TYPE_ID = A.ASSIGNMENT_STATUS_TYPE_ID
AND AST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN'
, 'ACTIVE_CWK') ))
AND LK.LOOKUP_TYPE = 'PA_PERSON_TYPE'
AND LK.LOOKUP_CODE = P.PERSON_TYPE

Columns