SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure [dbo].[p_claim_detail_by_claim_id]
	@claim_id int
as


	/*
	DGE

	Obtenir des détails sinistre en fonction de l'id


	*/

	set nocount on;


	select	p.pol_currency_code, p.pol_client_id
	from	claim_claims c
			inner join pol_policies_situations ps on ps.pols_policy_situation_id  = c.cl_policy_situation_id
			inner join pol_policies p on p.pol_policy_id = ps.pols_policy_id
	where	c.cl_claim_id = @claim_id

GO
