DBA Data[Home] [Help]

APPS.WF_PURGE dependencies on WF_ACTIVITY_TRANSITIONS

Line 882: delete from WF_ACTIVITY_TRANSITIONS WAT

878: where WPA.PROCESS_NAME = c_name
879: and WPA.PROCESS_ITEM_TYPE = c_item_type
880: and WPA.PROCESS_VERSION = ver.version);
881:
882: delete from WF_ACTIVITY_TRANSITIONS WAT
883: where WAT.TO_PROCESS_ACTIVITY in
884: (select WPA.INSTANCE_ID
885: from WF_PROCESS_ACTIVITIES WPA
886: where WPA.PROCESS_NAME = c_name

Line 890: delete from WF_ACTIVITY_TRANSITIONS WAT

886: where WPA.PROCESS_NAME = c_name
887: and WPA.PROCESS_ITEM_TYPE = c_item_type
888: and WPA.PROCESS_VERSION = ver.version);
889:
890: delete from WF_ACTIVITY_TRANSITIONS WAT
891: where WAT.FROM_PROCESS_ACTIVITY in
892: (select WPA.INSTANCE_ID
893: from WF_PROCESS_ACTIVITIES WPA
894: where WPA.PROCESS_NAME = c_name