SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure [dbo].[p_pr_families_get_all_tables]
	@family_code ais_code_short
as

	set nocount on;


	select	* 
	from	pr_families
	where	pf_family_code = @family_code

	select	*
	from	pr_families_cies
	where	prfc_family_code = @family_code

	select	*
	from	pr_families_formulas
	where	pff_family_code = @family_code

	select	*
	from	pr_families_formulas_variables
	where	pffv_family_code = @family_code

	select	*
	from	pr_families_natures
	where	pfn_family_code = @family_code

	select	*
	from	pr_families_variables 
	where	pfv_family_code = @family_code
	order by pfv_variable_code__parent			
GO
