Question: Is there a power sequence required for different supplies i.e. Vddio, Vdda, Vddd etc in PSoC3 and PSoC5?
No there is no power sequence required. However, Vdda should be the highest supply in the system. So, as far as Vdda is applied before other supplies or at the same time when other supplies are on, it is fine.