SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO



CREATE procedure [dbo].[p_grid_act_actors_addresses]
	@actor_id int
as

	/*
	DGE 0000252: Adresse de correspondance

	Cette procédure alimente la liste des adresses d'un acteur.

	*/
	select	*
	from	act_actors_addresses
			inner join adr_addresses on adr_address_id = adra_address_id
			--inner join nm_titles on nmtit_title_code = adr_title_code
	where	adra_actor_id = @actor_id




GO
