Help in query please

;With cteGroupCredit As
 (Select Group_code,code, code1,date1, cost_code,
   Row_Number() Over (Partition By Group_code,code, code1 Order By date1 Desc) As rn
 From #Group_credit),
 cteGroupCode As
 (Select g.Group_code, Count(*) As GroupCodeCount
 From #Code_values c
 Inner Join cteGroupCredit g On c.code = g.code And c.cost_code = g.cost_code And rn = 1
 Group By g.Group_code
 Having Count(*) = (Select Count(*) From #Code_values))
 Select *
 From #Code_values c
 Inner Join cteGroupCredit g On c.code = g.code And c.cost_code = g.cost_code And rn = 1
 Where g.Group_code In (Select cte.Group_code From cteGroupCode cte);

Tom