SELECT DISTINCT PER.PERSON_ID PERSON_ID , FULL_NAME , NATIONAL_IDENTIFIER , 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)