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
  • No labels