SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure [dbo].[p_tt_policies_situations_introducers]
	@policies_situations_table type_table_id readonly
as
	select	polsi.*, vi.*
	from	@policies_situations_table t 
			inner join pol_policies_situations_introducers polsi	on	polsi.polsi_policy_situation_id = t.id
			inner join vw_act_introducers vi						on	vi.act_actor_id = polsi.polsi_introducer_id

GO
