View solution ID 11489438 on support.cadence.com. It shows you how to use the "fanout -struct -endpoint" command to find all the flops in the fanout of any pin.
You can use the "gui_sv_cone <instance>" command to open any instance in a "cone" schematic GUI. Then you can right click on any pin of that instance and open in the fanin/fanout logic cone.
Hope this helps!