VIEW: APPS.PA_PARTIES_V

Source

View Text - Preformatted

SELECT 101, p.person_id, p.party_id, p.full_name, paf.organization_id, org.name FROM per_all_people_f p, per_all_assignments_f paf, hr_all_organization_units org WHERE 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(paf.effective_start_date) AND TRUNC(paf.effective_end_date) AND org.organization_id = paf.organization_id AND ((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.effective_start_date between p.effective_start_date and p.effective_end_date

View Text - HTML Formatted

SELECT 101
, P.PERSON_ID
, P.PARTY_ID
, P.FULL_NAME
, PAF.ORGANIZATION_ID
, ORG.NAME
FROM PER_ALL_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F PAF
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE 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(PAF.EFFECTIVE_START_DATE)
AND TRUNC(PAF.EFFECTIVE_END_DATE)
AND ORG.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND ((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.EFFECTIVE_START_DATE BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE