1154: v_unassigned_string VARCHAR2(20) := to_char(mth_util_pkg.mth_ua_get_val);
1155: v_mv_name varchar2(30);
1156: cursor getRefreshDate (p_mv_name in varchar2) is
1157: SELECT last_refresh_date 1158: FROM user_mviews 1159: WHERE mview_name = p_mv_name;
1160: BEGIN
1161: v_mv_name := UPPER(TRIM(p_mv_name));
1162: IF v_mv_name IS NULL OR LENGTH(v_mv_name) = 0 THEN