USE [LABORATORY]
GO
/****** Object:  StoredProcedure [dbo].[Lab_UpdateMedTech]    Script Date: 02/26/2020 3:03:51 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[Lab_CancelOPDRequests]


AS

update Station..tbnursecommunicationfile
set
revoke_date = getdate(), 
Revoke_Userid = '8',
Reason='Auto revoked by jobs.',
RecordStatus = 'R'
where RevenueId='LB' and RecordStatus='R'
and PatientType='O'
and
DATEDIFF(day, getdate(), requestDate) > = 3