APPS.AMW_DELETE_OBJECT_PVT dependencies on AMW_AP_TASKS

Line 362: DELETE FROM AMW_AP_TASKS WHERE audit_procedure_id = p_ap_id;

358: DELETE FROM AMW_AP_STEPS_TL WHERE ap_step_id in (SELECT ap_step_id FROM amw_ap_steps_b WHERE audit_procedure_id = p_ap_id);
359: DELETE FROM AMW_AP_STEPS_B WHERE audit_procedure_id = p_ap_id;
360:
361: -- Task
362: DELETE FROM AMW_AP_TASKS WHERE audit_procedure_id = p_ap_id;
363:
364: -- Extensible Attr
365: DELETE FROM AMW_AP_EXT_B WHERE audit_procedure_id = p_ap_id;
366: DELETE FROM AMW_AP_EXT_TL WHERE audit_procedure_id = p_ap_id;