APPS.AMW_ASSESSMENTS_PVT dependencies on AMW_ASSESS_PROCEDURE_STEPS_B

Line 50: from AMW_ASSESS_PROCEDURE_STEPS_B

46: IF (p_assess_procedure_id IS NOT NULL) THEN
47: delete from AMW_ASSESS_PROCEDURE_STEPS_TL
48: where ASSESS_PROCEDURE_STEP_ID IN (
49: select ASSESS_PROCEDURE_STEP_ID
50: from AMW_ASSESS_PROCEDURE_STEPS_B
51: where ASSESS_PROCEDURE_ID = p_assess_procedure_id
52: );
53:
54: delete from AMW_ASSESS_PROCEDURE_STEPS_B

Line 54: delete from AMW_ASSESS_PROCEDURE_STEPS_B

50: from AMW_ASSESS_PROCEDURE_STEPS_B
51: where ASSESS_PROCEDURE_ID = p_assess_procedure_id
52: );
53:
54: delete from AMW_ASSESS_PROCEDURE_STEPS_B
55: where ASSESS_PROCEDURE_ID = p_assess_procedure_id;
56:
57: delete from AMW_ASSESS_PROCEDURES_TL
58: where ASSESS_PROCEDURE_ID = p_assess_procedure_id;