SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure [dbo].[p_policies_introducers_info]
	@introducers_retro_codes type_table_id_code_short READONLY
as

	set nocount on;

	select wai.*, irc.*, ir.*
	from vw_act_introducers wai
		inner join @introducers_retro_codes irc on wai.int_actor_id = irc.id
		inner join int_retrocessions ir on ir.iret_retro_code = irc.code
GO
