Loan & Advance Deductions

-- fnGetLoanDeductionList query pattern
SELECT LoanId, LoanAmount, NoOfInstalment, CurrentDeductedAmt
FROM t_HR_LoansAndAdvances
WHERE EmployeeId = @EmployeeId
  AND IsActive = 1
  AND LoanDate <= @MonthAndYear
  AND Balance > 0