USP_BILLINGGENERATETRANSACTIONSCHARGEPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_BILLINGGENERATETRANSACTIONSCHARGEPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier
)
as
begin
    select
        ID, 
        NAME, 
        DESCRIPTION,
        IDSETREGISTERID, 
        TRANSACTIONDATE,
        CREATEOUTPUTIDSET,
        OUTPUTSELECTIONTYPEID,
        OUTPUTSELECTIONNAME,
        OVERWRITEOUTPUTSELECTION,
        CREATEEXCEPTIONIDSET,
        EXCEPTIONSELECTIONTYPEID,
        EXCEPTIONSELECTIONNAME,
        OVERWRITEEXCEPTIONSELECTION,
        dbo.UFN_BILLINGGENERATETRANSACTIONSPROCESS_GETBILLINGITEMS_TOITEMLISTXML(@ID) as BILLINGITEMS,
        dbo.UFN_BILLINGGENERATETRANSACTIONSPROCESS_GETSCHOOLS_TOITEMLISTXML(@ID) as SCHOOLS
    from
        dbo.BILLINGGENERATETRANSACTIONSPROCESS
    where
        ID = @ID        
end