USP_DATALIST_ACTIONITEMTARGET

CREATE procedure dbo.USP_DATALIST_ACTIONITEMTARGET
(
        @ACTIONITEMID uniqueidentifier
)
as
    set nocount on;

    select 
        ACTIONITEM_TARGET.[ID],
        ACTIONITEM_TARGET.[ACTIONITEMID],
        ACTIONITEM_TARGET.[ADVOCACYGROUPID],
        ACTIONITEM_TARGET.[LEGISID],
        ACTIONITEM_TARGET.[SENDTYPECODE],
        ACTIONITEM_TARGET.[TARGETTYPECODE],
        ACTIONITEM_TARGET.[STATE]
    from 
        dbo.ACTIONITEM_TARGET (NOLOCK)
    where
        ACTIONITEMID = @ACTIONITEMID