SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
create procedure [dbo].[p_claim_policy_detail]
	@policy_situation_id int
as 
	/*
	DGE

	Obtenir les informations suivantes:
	- code compagnie;
	- code famille
	*/

	set nocount on;


	select	pf_family_code, pol_company_id
	from	pol_policies_situations ps
			inner join pol_policies p on p.pol_policy_id = ps.pols_policy_id
			inner join pr_products on prd_product_code = p.pol_product_code
			inner join pr_families on pf_family_code = prd_family_code
	where	ps.pols_policy_situation_id = @policy_situation_id
	





GO
