SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[p_cies_info]
	@table_id type_table_id READONLY
AS
BEGIN

	-- retourner le code et le nom des compagnies

	SET NOCOUNT ON;
	SET XACT_ABORT ON;


	SELECT	v.act_actor_id,
			v.act_internal_reference, 
			v.adr_complete_name
	FROM	vw_act_cies v
			INNER JOIN @table_id t ON v.act_actor_id = t.id ;


END
GO
