VIEW: APPS.GHR_PEOPLE_V

Source

View Text - Preformatted

SELECT DISTINCT PER.PERSON_ID PERSON_ID , FULL_NAME , NATIONAL_IDENTIFIER , EMPLOYEE_NUMBER ,NATIONALITY FROM PER_PEOPLE_F PER WHERE per.effective_start_date = (select max(effective_start_date) from per_people_f ppf where ppf.person_id = per.person_id) and exists (select 1 from ghr_pa_requests par where par.person_id = per.person_id)

View Text - HTML Formatted

SELECT DISTINCT PER.PERSON_ID PERSON_ID
, FULL_NAME
, NATIONAL_IDENTIFIER
, EMPLOYEE_NUMBER
, NATIONALITY
FROM PER_PEOPLE_F PER
WHERE PER.EFFECTIVE_START_DATE = (SELECT MAX(EFFECTIVE_START_DATE)
FROM PER_PEOPLE_F PPF
WHERE PPF.PERSON_ID = PER.PERSON_ID)
AND EXISTS (SELECT 1
FROM GHR_PA_REQUESTS PAR
WHERE PAR.PERSON_ID = PER.PERSON_ID)