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)
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)
|
|
|