create procedure [dbo].[MssWebGetOrderClaimAlertDetail]
    @inOrderId int
as
begin
    set nocount on;
    ;with ClaimNotifcationType as ( select NoteTypeID from NoteType where NoteType = 'Claim Notification' )
    select
        AlertReceivedDate = Orders.AlertReceivedDate,
        NoteTypeId = NoteTypeId
    from Orders
    cross join ClaimNotifcationType
    where Orders.PriKey = @inOrderID
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderClaimAlertDetail] TO [MssExec]
GO