SELECT B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID, A.ACAD_PROG_PRIMARY, A.TOT_CUMULATIVE, C.EMAIL_ADDR FROM PS_STDNT_CAR_TERM A, PS_CU_BIO_VW B, PS_EMAIL_FERPA_VW C WHERE ( A.INSTITUTION = :1 AND A.STRM = :2 AND A.ACAD_CAREER = 'UGRD' AND A.TOT_CUMULATIVE > :3 AND A.UNT_TAKEN_PRGRSS > 0 AND A.EMPLID = B.EMPLID AND A.ACAD_PROG_PRIMARY = 'UGRD' AND A.EMPLID = C.EMPLID (+) AND 'CAMP' = C.E_ADDR_TYPE (+) ) ORDER BY 1, 2, 3 |