DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on ALL_TRIGGERS

Line 1232: FROM all_TRIGGERS TRG

1228: PROCEDURE DROP_MVIEW_TRIGGERS(mview_owner VARCHAR2, mview_name VARCHAR2) IS
1229: lv_sql varchar2(1000);
1230: begin
1231: for i in (SELECT trg.owner, trg.trigger_name
1232: FROM all_TRIGGERS TRG
1233: WHERE trg.table_owner = mview_owner and
1234: trg.table_name = mview_name
1235: )
1236: loop