140: );
141:
142: -- Step 3: insert all relationships
143:
144: INSERT INTO fem_entities_hier_t
145: ( hierarchy_object_name,
146: hierarchy_obj_def_display_name,
147: parent_display_code,
148: parent_value_set_display_code,
173: AND gcr.child_entity_id = fev_c.entity_id;
174:
175: -- we need to insert a record for the top node
176:
177: INSERT INTO fem_entities_hier_t
178: (
179: hierarchy_object_name,
180: hierarchy_obj_def_display_name,
181: parent_display_code,