VIEW: APPS.PA_CUR_EMP_V

Source

View Text - Preformatted

SELECT DISTINCT P.PERSON_ID , P.FULL_NAME , NVL(P.EMPLOYEE_NUMBER, P.NPW_NUMBER) , O.NAME , O.ORGANIZATION_ID , A.EFFECTIVE_START_DATE , A.EFFECTIVE_END_DATE , J.NAME , P.EFFECTIVE_START_DATE , P.EFFECTIVE_END_DATE FROM PER_PEOPLE_F P , PER_JOBS J, PER_ORGANIZATION_UNITS O, PER_ASSIGNMENTS_F A, PER_ASSIGNMENT_STATUS_TYPES AST1 WHERE A.ORGANIZATION_ID = O.ORGANIZATION_ID AND A.JOB_ID = J.JOB_ID AND A.JOB_ID IS NOT NULL AND A.ORGANIZATION_ID IS NOT NULL AND A.PRIMARY_FLAG = 'Y' AND A.ASSIGNMENT_TYPE IN ('E','C') AND AST1.ASSIGNMENT_STATUS_TYPE_ID = A.ASSIGNMENT_STATUS_TYPE_ID AND AST1.PER_SYSTEM_STATUS IN ( 'ACTIVE_ASSIGN' , 'ACTIVE_CWK') AND P.PERSON_ID = A.PERSON_ID AND ( P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL )

View Text - HTML Formatted

SELECT DISTINCT P.PERSON_ID
, P.FULL_NAME
, NVL(P.EMPLOYEE_NUMBER
, P.NPW_NUMBER)
, O.NAME
, O.ORGANIZATION_ID
, A.EFFECTIVE_START_DATE
, A.EFFECTIVE_END_DATE
, J.NAME
, P.EFFECTIVE_START_DATE
, P.EFFECTIVE_END_DATE
FROM PER_PEOPLE_F P
, PER_JOBS J
, PER_ORGANIZATION_UNITS O
, PER_ASSIGNMENTS_F A
, PER_ASSIGNMENT_STATUS_TYPES AST1
WHERE A.ORGANIZATION_ID = O.ORGANIZATION_ID
AND A.JOB_ID = J.JOB_ID
AND A.JOB_ID IS NOT NULL
AND A.ORGANIZATION_ID IS NOT NULL
AND A.PRIMARY_FLAG = 'Y'
AND A.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND AST1.ASSIGNMENT_STATUS_TYPE_ID = A.ASSIGNMENT_STATUS_TYPE_ID
AND AST1.PER_SYSTEM_STATUS IN ( 'ACTIVE_ASSIGN'
, 'ACTIVE_CWK')
AND P.PERSON_ID = A.PERSON_ID
AND ( P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL )