Nope, you're spot-on.
EVERY TIME a rogue (or assassin, or other sneak-attacking character) makes an attack against a target who is either flanked, flat-footed, or without his dex bonus against the rogue, the rogue can roll extra sneak-attack damage.
Yes, this makes properly-used rogues...