CREATE procedure [dbo].[MssWebGetOrderDependencyTasks]
    @inOrderId int,
    @inProfileId int,
    @inIdentifier varchar(64)
as
set nocount on
    select
        [Key]=Tasks.TaskID,
        [Value]=Tasks.TaskDescription    
    from ToDo
    inner join Tasks on Tasks.TaskID = ToDo.TaskID
    where
        ToDo.OrderID = @inOrderId and
        ToDo.ProfileID = @inProfileId and
        ToDo.Complete = 0 and
        ToDo.NotApplicableFlag = 0 and
        ToDo.Identifier = isnull(@inIdentifier,'')
    order by
        ToDo.DueDate asc,
        Tasks.TaskDescription desc
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderDependencyTasks] TO [MssExec]
GO