1493: ELSE
1494: FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS WHERE ui_style='7' AND deleted_flag='0' AND seeded_flag='0' AND
1495: ui_def_id IN(
1496: (SELECT ref_ui_def_id 1497: FROM cz_ui_refs 1498: START WITH ui_def_id = p_ui_def_id
1499: CONNECT by PRIOR ref_ui_def_id = ui_def_id AND
1500: deleted_flag = '0')
1501: UNION