VIEW: APPS.PA_PROJECT_PLAYER_V

Source

View Text - Preformatted

SELECT p.person_id , p.full_name ,p.employee_number , paf.organization_id , ou.name organization_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 ) ) 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' ) union all SELECT p.person_id , p.full_name , 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_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' )

View Text - HTML Formatted

SELECT P.PERSON_ID
, P.FULL_NAME
, P.EMPLOYEE_NUMBER
, PAF.ORGANIZATION_ID
, OU.NAME ORGANIZATION_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 ) )
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' ) UNION ALL SELECT P.PERSON_ID
, P.FULL_NAME
, 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_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' )