USP_CLOSINGREQUIREMENT_GETBALANCINGSEGMENTS

create procedure dbo.USP_CLOSINGREQUIREMENT_GETBALANCINGSEGMENTS
as
begin
    select CLOSINGREQUIREMENT.DATAELEMENTID, IDSETREGISTER.DBOBJECTNAME, PDACCOUNTSTRUCTURE.SEGMENTCOLUMN, 
  CLOSINGREQUIREMENTDETAIL.ACCOUNTREQUIREMENTSCODE, PDACCOUNTSTRUCTURE.DESCRIPTION
  from dbo.CLOSINGREQUIREMENT inner join dbo.CLOSINGREQUIREMENTDETAIL on CLOSINGREQUIREMENT.ID = CLOSINGREQUIREMENTDETAIL.CLOSINGREQUIREMENTID
  left join dbo.IDSETREGISTER on CLOSINGREQUIREMENT.DATAELEMENTQUERYID = IDSETREGISTER.ID
  inner join dbo.PDACCOUNTSTRUCTURE on CLOSINGREQUIREMENTDETAIL.ACCOUNTSTRUCTUREID = PDACCOUNTSTRUCTURE.ID
  where CLOSINGREQUIREMENTDETAIL.REQUIRETOBALANCE = 1
  and (CLOSINGREQUIREMENTDETAIL.ACCOUNTREQUIREMENTSCODE = 2 OR CLOSINGREQUIREMENTDETAIL.ACCOUNTREQUIREMENTSCODE = 3)
end