3131: -- statement to update all lines.
3132: -- We update the field task name.
3133: UPDATE CSD_REPAIR_HISTORY HIST
3134: SET HIST.PARAMC7 = ( SELECT task_name
3135: FROM JTF_TASKS_VL
3136: WHERE task_id = HIST.paramn1
3137: )
3138: WHERE HIST.EVENT_CODE IN ('TC', 'TOC', 'TSC')
3139: AND HIST.REPAIR_HISTORY_ID >= v_min