USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTMEMBERSHIPINSTALLMENTS

CREATE procedure dbo.USP_DATALIST_PDACCOUNTCODEMAPDEVELOPMENTMEMBERSHIPINSTALLMENTS (
    @ID uniqueidentifier
)
as
    set nocount on;

    declare @MEMBERSHIPINSTALLMENTACCOUNTCODEMAPOFFICEID uniqueidentifier = 'D38E0F1D-845F-42CD-837E-8030F538A32B'

    select
        PDACCOUNTCODEMAPPING.ID,
        dbo.UFN_PDACCOUNTCODEMAPREVENUETYPE_TYPENAMESTRING(@MEMBERSHIPINSTALLMENTACCOUNTCODEMAPOFFICEID, PDACCOUNTCODEMAPPING.REVENUETYPE) REVENUETYPE,
        case 
            when (REVENUETYPE & 52) <> 0 then dbo.UFN_PDACCOUNTCODEMAPWRITEOFFREASONCODES_NAMESTRING (PDACCOUNTCODEMAPPING.ID)
            else null
        end as REASONCODES,
        isnull(DEBITACCOUNT.ACCOUNTNUMBER, '') as DEBITACCOUNT,
        DEBITCODE.SHORTDESCRIPTION as DEBITCODE,
        isnull(CREDITACCOUNT.ACCOUNTNUMBER, '') as CREDITACCOUNT,
        CREDITCODE.SHORTDESCRIPTION as CREDITCODE
    from dbo.PDACCOUNTCODEMAPPING
    left join dbo.GLACCOUNT DEBITACCOUNT on
        PDACCOUNTCODEMAPPING.DEBITGLACCOUNTID = DEBITACCOUNT.ID
    left join dbo.GLACCOUNT CREDITACCOUNT on
        PDACCOUNTCODEMAPPING.CREDITGLACCOUNTID = CREDITACCOUNT.ID
    left join dbo.PDACCOUNTSEGMENTVALUE DEBITCODE on
        PDACCOUNTCODEMAPPING.DEBITPDACCOUNTSEGMENTVALUEID = DEBITCODE.ID
    left join dbo.PDACCOUNTSEGMENTVALUE as CREDITCODE on
        PDACCOUNTCODEMAPPING.CREDITPDACCOUNTSEGMENTVALUEID = CREDITCODE.ID
    where PDACCOUNTCODEMAPPING.PDACCOUNTCODEMAPOFFICEID = @MEMBERSHIPINSTALLMENTACCOUNTCODEMAPOFFICEID
    and PDACCOUNTCODEMAPPING.PDACCOUNTSYSTEMID = @ID