DBA Data[Home] [Help]

APPS.AMS_WFTRIG_PVT dependencies on AMS_TRIGGER_RESULTS

Line 3793: Delete from ams_trigger_results

3789: write_msg('purge_history','Starting to purge Monitor history...');
3790: write_msg('purge_history','History for all triggers that have ended more than '||trig_end_date_days||' days is being deleted...');
3791: END IF;
3792:
3793: Delete from ams_trigger_results
3794: where trigger_result_for_id in
3795: (SELECT trigger_id
3796: FROM ams_triggers
3797: WHERE (repeat_stop_date_time + trig_end_date_days) < sysdate);