SELECT Dep_ID FROM #Request.prefix_db_agency#.pDeposit
WHERE Remit_No =
AND Status = 0
AND Dep_ID <>
UPDATE #Request.prefix_db_agency#.pDeposit SET
Date_Check = #CreateODBCDate(form.Date_Check)#
,Date_Deposit = #CreateODBCDate(form.Date_Deposit)#
,Remit_No = '#form.Remit_No#'
,Check_Total = '#form.Check_Total#'
WHERE Dep_ID = '#url.Dep_ID#'
SELECT pDeposit.*,Invoices.PatientPayer_ID,pPayer.Pay_ID FROM #Request.prefix_db_agency#.pDeposit
LEFT OUTER JOIN #Request.prefix_db_agency#.Invoices ON Invoices.Internal_control_number = pDeposit.Internal_control_number
AND Invoices.Deleted = 0
LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer ON Invoices.PatientPayer_ID = pPayer.Pay_ID
WHERE pDeposit.Dep_ID = '#url.Dep_ID#'
AND pDeposit.Status = 0
GROUP BY pDeposit.Dep_ID