VIEW: APPS.PA_EMPLOYEES_RES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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