DBA Data[Home] [Help]

APPS.WF_PURGE dependencies on WF_ACTIVITY_ATTR_VALUES

Line 868: delete from WF_ACTIVITY_ATTR_VALUES WAAV

864: -- Purge the activity if no reference found
865:
866: -- Delete any process activities and
867: -- their attribute values and transitions
868: delete from WF_ACTIVITY_ATTR_VALUES WAAV
869: where WAAV.PROCESS_ACTIVITY_ID in
870: (select WPA.INSTANCE_ID
871: from WF_PROCESS_ACTIVITIES WPA
872: where WPA.PROCESS_NAME = c_name