FND Design Data [Home] [Help]

View: PA_CUR_EMP_V

Product: PA - Projects
Description: For Online Expenditure Entry Form
Implementation/DBA Data: ViewAPPS.PA_CUR_EMP_V
View Text

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 )

Columns

Name
PERSON_ID
EMPLOYEE_NAME
EMPLOYEE_NUMBER
ORGANIZATION_NAME
ORGANIZATION_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
JOB_NAME
EMP_EFF_START_DATE
EMP_EFF_END_DATE