UFN_CLOSINGREQUIREMENTDETAIL

 CREATE function dbo.UFN_CLOSINGREQUIREMENTDETAIL(@CLOSINGREQUIREMENTID uniqueidentifier)
            returns table
            as return
            SELECT CLOSINGREQUIREMENTDETAIL.ID, ACCOUNTSTRUCTUREID,
      dbo.UFN_TRANSLATIONFUNCTION_ACCOUNTSTRUCTURE_NAME(ACCOUNTSTRUCTUREID) as SEGMENTNAME ,
      PRESERVEDETAILSDURINGCLOSING, REQUIRETOBALANCE,ACCOUNTREQUIREMENTSCODE,PDACCOUNTSTRUCTURE.ELEMENTTYPECODE,
      CLOSINGREQUIREMENTID
      FROM CLOSINGREQUIREMENTDETAIL inner join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSTRUCTURE.ID = CLOSINGREQUIREMENTDETAIL.ACCOUNTSTRUCTUREID
            WHERE CLOSINGREQUIREMENTID = @CLOSINGREQUIREMENTID