624: cv CurTyp;
625:
626: CURSOR cZeroMV(p_pattern varchar2) IS
627: SELECT mview_name 628: FROM all_mviews 629: WHERE mview_name like p_pattern
630: AND owner in (BSC_METADATA_OPTIMIZER_PKG.gBSCSchema,BSC_METADATA_OPTIMIZER_PKG.gAppsSchema);
631: l_mvname VARCHAR2(100);
632: