View: PA_PROJECT_PLAYERS_ALL_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_PROJECT_PLAYERS_ALL_V

View Text

SELECT P.PERSON_ID
, P.FULL_NAME
, DECODE(P.CURRENT_EMPLOYEE_FLAG
, 'Y'
, P.EMPLOYEE_NUMBER
, P.NPW_NUMBER)
, L.MEANING
FROM PER_PEOPLE_F P
, PA_LOOKUPS L
WHERE L.LOOKUP_TYPE = 'PA_PERSON_TYPE'
AND L.LOOKUP_CODE = DECODE(P.CURRENT_EMPLOYEE_FLAG
, 'Y'
, 'EMP'
, 'CWK')
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND ((P.EMPLOYEE_NUMBER IS NOT NULL
AND P.CURRENT_EMPLOYEE_FLAG = 'Y') OR (P.NPW_NUMBER IS NOT NULL
AND P.CURRENT_NPW_FLAG = 'Y'))
AND EXISTS (SELECT NULL FROM PA_PROJECT_PLAYERS PP
, PA_PROJECTS PR WHERE PP.PERSON_ID = P.PERSON_ID AND PP.PROJECT_ID = PR.PROJECT_ID )

Columns