Line 966: -- not using sys.snap$ because it is against apps standard
962: ;
963:
964: /**
965: ---this cursor checks hanging MV 966: -- not using sys.snap$ because it is against apps standard 967: l_check_hanging_mv varchar2(2000):='
968: select ''Y''
969: from dual
970: where not exists