Given two complete hereditary cotorsion pairs (𝒬,ℛ) and (𝒬′,ℛ′) in the category of modules which satisfy the conditions 𝒬^′⊆𝒬, 𝒬∩ℛ=𝒬′∩ℛ′, and ℛ^′ is enveloping, a kind of Tate homology Tor̂∗𝒬ℳ of modules is introduced and investigated in this article based on complete (𝒬′∩ℛ′)-resolutions. It is shown that a module admits complete (𝒬′∩ℛ′)-resolutions precisely when it has finite 𝒬-projective dimension. In particular, an Avramov–Martsinkovsky type exact sequence, which is natural in both variables, is constructed to connect such Tate homology functors and relative homology functors. Applications given for the subcategory 𝒢ℱ of Gorenstein flat modules go in three directions. The first is to improve the Avramov–Martsinkovsky type exact sequence appeared in Liang’s work [Tate homology of modules of finite Gorenstein flat dimension. Algebr. Represent. Theory 16:1541–1560 (2013)] by showing that it is indeed natural in both variables. The second is to characterize the finiteness of Gorenstein flat (resp., flat) dimension by using vanishing of Tate homology functors Tor̂∗𝒢ℱℳ(−,−). Finally, by virtue of a conclusion provided by Enochs et al., some balance results are established for Tor̂∗𝒢ℱℳ.