SELECT B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID, A.SRVC_IND_CD, A.SRVC_IND_REASON, A.SRVC_IND_ACT_TERM, TO_CHAR(A.SRVC_IND_ACTIVE_DT,'YYYY-MM-DD'), sum ( C.ACCOUNT_BALANCE) FROM PS_SRVC_IND_DATA A, PS_CU_BIO_VW B, PS_ACCOUNT_SF C WHERE A.INSTITUTION = :1 AND A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.INSTITUTION = C.BUSINESS_UNIT AND C.ACCOUNT_TERM <= :2 AND A.SRVC_IND_CD = :3 AND ( A.SRVC_IND_REASON = :4 OR :4 IS NULL) GROUP BY B.LAST_NAME, B.FIRST_NAME, B.MIDDLE_NAME, A.EMPLID, A.SRVC_IND_CD, A.SRVC_IND_REASON, A.SRVC_IND_ACT_TERM, TO_CHAR(A.SRVC_IND_ACTIVE_DT,'YYYY-MM-DD') HAVING sum ( C.ACCOUNT_BALANCE) <= 0 ORDER BY 1, 2, 3 |