SELECT EJS_PERSON_PKG.GET_PERSON_SUMMARY(MN.PER_PERSON_ID,MN.MN_ID,'N','N') || ' (' || JOIN(CURSOR(SELECT RC.ROLE_DESC FROM INCIDENT_PERSON_ROLES IPR INNER JOIN ROLE_CODES RC ON IPR.ROLE_TYPE = RC.ROLE_TYPE WHERE IPR.INC_PER_ID = IP.INC_PER_ID)) || ')' AS DISPLAY, MN.PER_PERSON_ID AS VAL_1, MN.MN_ID AS VAL_2, NULL AS VAL_3, NULL AS VAL_4, NULL AS VAL_5, IP.INC_INCIDENT_ID AS KEY_VAL_1, IP.SUPP_SEQ AS KEY_VAL_2, NULL AS KEY_VAL_3, NULL AS KEY_VAL_4, NULL AS KEY_VAL_5 FROM INCIDENT_PEOPLE IP INNER JOIN MASTER_NAMES MN ON IP.MN_MN_ID = MN.MN_ID AND IP.PER_PERSON_ID = MN.PER_PERSON_ID