947: where parent_level + 1 = child_level
948: --and child_flex_value_set_id = G_MASTER_VALUE_SET_ID
949: union all
950: select NULL, -999, 0, -998, 'N' 951: from dual 952: )
953: START WITH pid is null
954: CONNECT BY pid = PRIOR cid
955: ORDER siblings BY cid;