25: l_zpb_pref varchar2(8);
26:
27: CURSOR c_sharedViews is
28: select table_name 29: from zpb_tables 30: where (table_name like 'ZPBDATA%' or table_name like 'ZPB'||p_Business_Area_id||'_D%') and
31: bus_area_id = p_business_area_id;
32:
33: v_sharedView c_sharedViews%ROWTYPE;