SELECT P.FULL_NAME , P.PERSON_ID FROM PER_ALL_PEOPLE_F P WHERE TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE UNION SELECT P.FULL_NAME , P.PERSON_ID FROM PER_ALL_PEOPLE_F P WHERE P.EFFECTIVE_START_DATE = (SELECT MIN(P2.EFFECTIVE_START_DATE) FROM PER_ALL_PEOPLE_F P2 WHERE P2.PERSON_ID=P.PERSON_ID) AND P.EFFECTIVE_START_DATE > TRUNC(SYSDATE)