Versions Compared

Old Version 1

changes.mady.by.user Tabassum Lodhi

Saved on

compared with

New Version Current

changes.mady.by.user Tabassum Lodhi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 
 
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