SELECT CEI.CONTACT_EXTRA_INFO_ID , CEI.EFFECTIVE_START_DATE , CEI.EFFECTIVE_END_DATE , EMP.FULL_NAME , CON.FULL_NAME , SUBSTR(HR_GENERAL.DECODE_LOOKUP('CONTACT' , REL.CONTACT_TYPE) , 1 , 80) , CITT.DESCRIPTION , CEI.LAST_UPDATE_DATE , USR.USER_NAME FROM PER_CONTACT_EXTRA_INFO_F CEI , PER_ALL_PEOPLE_F EMP , PER_ALL_PEOPLE_F CON , PER_CONTACT_RELATIONSHIPS REL , PER_CONTACT_INFO_TYPES_TL CITT , FND_USER USR WHERE CEI.CONTACT_RELATIONSHIP_ID = REL.CONTACT_RELATIONSHIP_ID AND REL.PERSON_ID = EMP.PERSON_ID AND REL.CONTACT_PERSON_ID = CON.PERSON_ID AND CEI.INFORMATION_TYPE = CITT.INFORMATION_TYPE AND CITT.LANGUAGE = USERENV('LANG') AND CEI.LAST_UPDATED_BY = USR.USER_ID(+) AND CEI.EFFECTIVE_START_DATE BETWEEN NVL(EMP.EFFECTIVE_START_DATE , CEI.EFFECTIVE_START_DATE) AND NVL(EMP.EFFECTIVE_END_DATE , CEI.EFFECTIVE_START_DATE) AND CEI.EFFECTIVE_START_DATE BETWEEN NVL(CON.EFFECTIVE_START_DATE , CEI.EFFECTIVE_START_DATE) AND NVL(CON.EFFECTIVE_END_DATE , CEI.EFFECTIVE_START_DATE) AND CEI.EFFECTIVE_START_DATE BETWEEN NVL(REL.DATE_START , CEI.EFFECTIVE_START_DATE) AND NVL(REL.DATE_END , CEI.EFFECTIVE_START_DATE) WITH READ ONLY