USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTACCOUNTDETAIL

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTACCOUNTDETAIL
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @CONDITIONSETTINGNAME nvarchar(50) = null output,
    @MANDATES xml = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @CONDITIONSETTINGNAME = BANKINGSYSTEM.CONDITIONSETTINGNAME
    from
        dbo.CONSTITUENTACCOUNT
        inner join dbo.FINANCIALINSTITUTION on FINANCIALINSTITUTION.ID = CONSTITUENTACCOUNT.FINANCIALINSTITUTIONID
        left join dbo.BANKINGSYSTEM on BANKINGSYSTEM.ID = FINANCIALINSTITUTION.BANKINGSYSTEMID
    where
        CONSTITUENTACCOUNT.ID = @ID;

    set @MANDATES = dbo.UFN_CONSTITUENTACCOUNT_GETMANDATES_TOITEMLISTXML(@ID);

    return 0;