SELECT PIT.PERSON_ID_TYPE , API.API_PERSON_ID , API.PE_PERSON_ID FROM IGS_PE_PERSON_ID_TYP PIT , IGS_PE_ALT_PERS_ID API WHERE API.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE AND PIT.PREFERRED_IND = 'Y' AND SYSDATE BETWEEN API.START_DT AND NVL(API.END_DT , SYSDATE)