UFN_BENEFIT_GETGLDISTRIBUTION

create function dbo.UFN_BENEFIT_GETGLDISTRIBUTION(@REVENUEID uniqueidentifier) 
            returns table
            as 
            return (
                    select 
                        BENEFITGLDISTRIBUTION.ID, 
                        BENEFITGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID, 
                        BENEFITGLDISTRIBUTION.TRANSACTIONTYPECODE,
                        BENEFITGLDISTRIBUTION.TRANSACTIONTYPE as DEBITCREDIT,
                        BENEFITGLDISTRIBUTION.ACCOUNT, 
                        BENEFITGLDISTRIBUTION.PROJECT, 
                        BENEFITGLDISTRIBUTION.AMOUNT, 
                        BENEFITGLDISTRIBUTION.REFERENCE,
                        BENEFITGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                        BENEFITGLDISTRIBUTION.BASECURRENCYID,
                        BENEFITGLDISTRIBUTION.TRANSACTIONAMOUNT,
                        BENEFITGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        BENEFITGLDISTRIBUTION.BASEEXCHANGERATEID,
                        BENEFITGLDISTRIBUTION.ORGANIZATIONEXCHANGERATEID,
                        BENEFITGLDISTRIBUTION.REVENUEBENEFITID
                    from 
                        dbo.BENEFITGLDISTRIBUTION  
                        join dbo.GLTRANSACTION on BENEFITGLDISTRIBUTION.GLTRANSACTIONID = GLTRANSACTION.ID
                    where 
                        BENEFITGLDISTRIBUTION.REVENUEID = @REVENUEID
                        and BENEFITGLDISTRIBUTION.BENEFITTYPECODE = 1
                        and BENEFITGLDISTRIBUTION.OUTDATED = 0 and GLTRANSACTION.POSTSTATUSCODE = 1
            )