Line 32: select nvl(ltrim(rtrim(upper(p_mv_name))), '@@@') into l_mv_name from dual;
28: BEGIN
29: msc_util.msc_log('Begin REFRESH_MAT_VIEWS');
30: RETCODE:= G_SUCCESS;
31: 32: select nvl(ltrim(rtrim(upper(p_mv_name))), '@@@') into l_mv_name from dual; 33:
34: OPEN application_schema;
35: FETCH application_schema INTO l_schema_name;
36: CLOSE application_schema;