* Scraps plan after resistance from US foreign investment board (Adds comment on foot-dragging by CFIUS on Chinese investments) : FRANKFURT (Reuters) - A Chinese-led group has withdrawn its offer to buy a stake in German carmaker-backed mapping company HERE after it failed to win approval from a U.S. national security oversight board. Chinese mapping company Navinfo (002405.SZ) said on Tuesday that the company and partners Chinese internet giant Tencent (0700.HK) and Singapore sovereign wealth fund GIC [GIC.UL] had dropped plans to take a 10 percent stake in the company.