DBA Data[Home] [Help]

APPS.AMW_ASSESSMENTS_PVT dependencies on AMW_ASSESS_PROCEDURE_STEPS_TL

Line 47: delete from AMW_ASSESS_PROCEDURE_STEPS_TL

43:
44: x_return_status := G_RET_STS_SUCCESS;
45:
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