[Home] [Help]
870: -- Purge the activity if no reference found
871:
872: -- Delete any process activities and
873: -- their attribute values and transitions
874: delete from WF_ACTIVITY_ATTR_VALUES WAAV
875: where WAAV.PROCESS_ACTIVITY_ID in
876: (select WPA.INSTANCE_ID
877: from WF_PROCESS_ACTIVITIES WPA
878: where WPA.PROCESS_NAME = c_name