SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_grid_act_treaties_companies]
	@actor_id int
AS
BEGIN
	SET NOCOUNT ON;
	
	SELECT *
	FROM	act_treaties_companies
		inner join act_actors on trtc_company_id = act_actor_id -- join with company actor to get the company name
	WHERE	trtc_actor_id = @actor_id

END



GO
