DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on ALL_TRIGGERS

Line 1505: FROM all_TRIGGERS TRG

1501: PROCEDURE DROP_MVIEW_TRIGGERS(mview_owner VARCHAR2, mview_name VARCHAR2) IS
1502: lv_sql varchar2(1000);
1503: begin
1504: for i in (SELECT trg.owner, trg.trigger_name
1505: FROM all_TRIGGERS TRG
1506: WHERE trg.table_owner = mview_owner and
1507: trg.table_name = mview_name
1508: )
1509: loop