VIEW: APPS.PA_PROJECT_PLAYERS_ALL_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )