DBA Data[Home] [Help]

APPS.AMW_DELETE_OBJECT_PVT dependencies on AMW_AP_STEPS_TL

Line 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);

354: FROM AMW_AUDIT_PROCEDURES_B
355: WHERE audit_procedure_id = p_ap_id;
356:
357: -- Step
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;