Gerard,
What requires you to regen these exactly? Can they be parameterized views instead?
>I'll have a go at your suggeation.. my only concern is that some of the tables can be quite large (They are only used in these forms for enquiry purposes) and creating a cursor intoduces another overhead.