SELECT  ab.id AS accountBalanceId,
        ab.incentiveaccountid AS incentiveAccountId,
        ab.datebalance AS dateBalance,
        ab.balanceamount AS balanceAmount,
        ia.status AS incentiveAccountStatus,
  ia.termsflag
FROM AEPE_INCENTIVE.ACCOUNTBALANCE ab
  JOIN AEPE_INCENTIVE.INCENTIVEACCOUNT ia ON ab.INCENTIVEACCOUNTID = ia.ID
  join AEPE_INCENTIVE.ACCOUNTPARTY ap ON ap.INCENTIVEACCOUNTID = ia.ID
WHERE
  ap.PARTYID = #{partyId}
ORDER BY ab.DATECREATED DESC
FETCH FIRST 1 ROWS ONLY