The case against a former West Yorkshire Police officer who was charged in connection with an investigation into historic child sexual exploitation has been dropped.