Query SQL:
SELECT B.EMPLID, A.ACCOUNT_BALANCE, sum ( B.NET_AWARD_AMT)
FROM PS_ANTICIPATED_AID B, PS_ACCOUNT_SF A
WHERE B.AS_OF_DTTM = (SELECT max ( C.AS_OF_DTTM)
FROM PS_ANTICIPATED_AID C
WHERE C.EMPLID = B.EMPLID
AND C.INSTITUTION = B.INSTITUTION
AND C.AID_YEAR = B.AID_YEAR
AND C.ITEM_TYPE = B.ITEM_TYPE
AND C.ACAD_CAREER = B.ACAD_CAREER
AND C.DISBURSEMENT_PLAN = B.DISBURSEMENT_PLAN
AND C.DISBURSEMENT_ID = B.DISBURSEMENT_ID
AND C.STRM = B.STRM)
AND B.INSTITUTION = :1
AND B.STRM = :2
AND B.EMPLID = A.EMPLID
AND B.INSTITUTION = A.BUSINESS_UNIT
AND B.STRM = A.ACCOUNT_TERM
AND A.ACCOUNT_BALANCE > 0
GROUP BY B.EMPLID, A.ACCOUNT_BALANCE
HAVING A.ACCOUNT_BALANCE - sum ( B.NET_AWARD_AMT) <= 0
ORDER BY 1