VIEW: APPS.PA_PROJECT_PLAYER_V

Source

View Text - Preformatted

SELECT p.person_id ,p.full_name ,decode(p.current_employee_flag,'Y',p.employee_number,p.npw_number) ,paf.organization_id ,ou.name ,p.effective_start_date , decode(p.current_npw_flag ,'Y','CWK','EMP') FROM per_people_f p , per_all_assignments_f paf, hr_all_organization_units_tl ou WHERE ((p.current_employee_flag = 'Y' AND p.employee_number IS NOT NULL) or (p.current_npw_flag = 'Y' AND p.npw_number IS NOT NULL)) AND paf.person_id = p.person_id AND paf.primary_flag = 'Y' AND paf.assignment_type in ('E', 'C') AND paf.job_id IS NOT NULL AND ( ( TRUNC(SYSDATE) BETWEEN TRUNC(p.effective_start_date) AND TRUNC(p.effective_end_date) AND TRUNC(SYSDATE) BETWEEN TRUNC(paf.effective_start_date) AND TRUNC(paf.effective_end_date)) OR ( TRUNC(SYSDATE) < TRUNC(p.effective_start_date) AND TRUNC(p.effective_start_date) BETWEEN TRUNC(paf.effective_start_date) AND TRUNC(paf.effective_end_date))) AND ou.organization_id = paf.organization_id AND ou.language = userenv('LANG') ORDER BY p.full_name

View Text - HTML Formatted

SELECT P.PERSON_ID
, P.FULL_NAME
, DECODE(P.CURRENT_EMPLOYEE_FLAG
, 'Y'
, P.EMPLOYEE_NUMBER
, P.NPW_NUMBER)
, PAF.ORGANIZATION_ID
, OU.NAME
, P.EFFECTIVE_START_DATE
, DECODE(P.CURRENT_NPW_FLAG
, 'Y'
, 'CWK'
, 'EMP')
FROM PER_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F PAF
, HR_ALL_ORGANIZATION_UNITS_TL OU
WHERE ((P.CURRENT_EMPLOYEE_FLAG = 'Y'
AND P.EMPLOYEE_NUMBER IS NOT NULL) OR (P.CURRENT_NPW_FLAG = 'Y'
AND P.NPW_NUMBER IS NOT NULL))
AND PAF.PERSON_ID = P.PERSON_ID
AND PAF.PRIMARY_FLAG = 'Y'
AND PAF.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND PAF.JOB_ID IS NOT NULL
AND ( ( TRUNC(SYSDATE) BETWEEN TRUNC(P.EFFECTIVE_START_DATE)
AND TRUNC(P.EFFECTIVE_END_DATE)
AND TRUNC(SYSDATE) BETWEEN TRUNC(PAF.EFFECTIVE_START_DATE)
AND TRUNC(PAF.EFFECTIVE_END_DATE)) OR ( TRUNC(SYSDATE) < TRUNC(P.EFFECTIVE_START_DATE)
AND TRUNC(P.EFFECTIVE_START_DATE) BETWEEN TRUNC(PAF.EFFECTIVE_START_DATE)
AND TRUNC(PAF.EFFECTIVE_END_DATE)))
AND OU.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND OU.LANGUAGE = USERENV('LANG') ORDER BY P.FULL_NAME