create procedure [dbo].[MssWebResetJobCostingOnAcceptedQuote]
    @inOrderID int,
    @inQuoteHeaderFID int

as
begin
    set nocount on

    declare @quoteStatusName varchar(128)

    select
        @quoteStatusName = QuoteStatus.[Description]
    from QuoteHeader
    inner join QuoteStatus on QuoteHeader.QuoteStatusFID = QuoteStatus.QuoteStatusID
    where QuoteHeader.QuoteHeaderID = @inQuoteHeaderFID

    if ( @quoteStatusName = 'Accepted' )
    begin
        update Orders
        set JobCostingCalculated = 0
        where PriKey = @inOrderID
          and Orders.ReleaseDate is null
    end
end
GO
GRANT EXECUTE ON  [dbo].[MssWebResetJobCostingOnAcceptedQuote] TO [MssExec]
GO