A high-ranking member of the LAPD was apparently caught having sex with a female subordinate in public after being tailed by his own undercover officers