Line 3319: select 1 from user_objects where object_name = p_higher_level and object_type='VIEW';
3315: and rels.table_name not like p_lower_level
3316: and rels.table_name like 'BSC_S%';
3317:
3318: cursor cView(p_higher_level varchar2) is 3319: select 1 from user_objects where object_name = p_higher_level and object_type='VIEW'; 3320: ----------------------------
3321: l_res number;
3322: l_higher_level varchar2(100);
3323: Begin