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

-- family formulas
exec p_grid_pr_families_formulas @family_code = @family_code, @formula_code = '%'

-- risk movements
select	*
from	nm_risks_movements

-- risk natures
select	* 
from	pr_families_natures a
where	a.pfn_family_code = @family_code

GO
