956: where parent_level + 1 = child_level
957: --and child_flex_value_set_id = G_MASTER_VALUE_SET_ID
958: union all
959: select NULL, -999, 0, -998, 'N' 960: from dual 961: )
962: START WITH pid is null
963: CONNECT BY pid = PRIOR cid
964: ORDER siblings BY cid;