I don't really see why you would ever need to use a cursor in this situation. If I'm correct in reading your initial description there is a simple hierarchical relationship...