SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE procedure [dbo].[p_acc_advance_get_by_id]
	@account_id int
AS


/*
	DGE 07/03/2017
	Obtenir les informations d'un acompte.
	
*/

	set nocount on;


	select	*
	from	acc_accounts
	where	a_account_id = @account_id

	select	*
	from	acc_advances
	where	adv_advance_id = @account_id



GO
