USP_FEEDALERTINSTANCE_GETWORKFLOWTRIGGERSLIST

CREATE procedure dbo.USP_FEEDALERTINSTANCE_GETWORKFLOWTRIGGERSLIST
(
    @FEEDALERTINSTANCEID uniqueidentifier
)    
as
    select WFT.ID,
           WF.NAME as WORKFLOWNAME, 
           WF.DATAFORMINSTANCECATALOGID, 
           WFT.WORKFLOWARGSMAP,
           coalesce(WFT.DATELASTPROCESSED, WFT.DATEADDED) as DATELASTPROCESSED,
           WFT.WORKFLOWID
    from dbo.FEEDALERTINSTANCEWORKFLOWTRIGGER WFT inner join dbo.BBWORKFLOWCATALOG WF on WFT.WORKFLOWID = WF.ID
         left outer join dbo.DATAFORMINSTANCECATALOG INSTANCE on WF.DATAFORMINSTANCECATALOGID = INSTANCE.ID
         left outer join dbo.DATAFORMTEMPLATECATALOG TEMPLATE on INSTANCE.DATAFORMTEMPLATECATALOGID = TEMPLATE.ID
    where (WFT.FEEDALERTINSTANCEID = @FEEDALERTINSTANCEID) and (WFT.ENABLED = 1)