ACS3 Data Model

     1: function hp_get_neighborhood_root_node return integer
     2: IS
     3: 	CURSOR root_cursor IS
     4: 		select neighborhood_id
     5:  		from users_neighborhoods
     6:         	where parent_id is null;
     7: 	root_id		integer;
     8: BEGIN
     9: 	OPEN root_cursor;
    10: 	FETCH root_cursor INTO root_id;
    11: 	CLOSE root_cursor;
    12: 	return root_id;
    13: END;