SELECT * FROM dbo.Recibos r
WHERE CONVERT(VARCHAR, r.FechaCreacion, 112) = 20220420
AND r.Contrato_ContratoId IN (
SELECT cc.Contrato_ContratoId FROM dbo.ContratoCuotas cc
INNER JOIN Contratos co ON co.ContratoId = cc.Contrato_ContratoId
WHERE CONVERT(VARCHAR,cc.FechaCuota,112) < CONVERT(VARCHAR,GETDATE(),112) AND
CONVERT(VARCHAR,cc.FechaPagada,112) > CONVERT(VARCHAR,co.FechaUltimaCuota,112)
)