APPS.CSM_HA_EVENT_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 504: delete from WF_ITEM_ACTIVITY_STATUSES_H

500: -- Copy of wfrmitt.sql
501: PROCEDURE WFRMITT(p_item_type IN VARCHAR2)
502: IS
503: BEGIN
504: delete from WF_ITEM_ACTIVITY_STATUSES_H
505: where PROCESS_ACTIVITY in
506: (select INSTANCE_ID from WF_PROCESS_ACTIVITIES
507: where PROCESS_ITEM_TYPE = p_item_type
508: or ACTIVITY_ITEM_TYPE = p_item_type);

Line 510: delete from WF_ITEM_ACTIVITY_STATUSES

506: (select INSTANCE_ID from WF_PROCESS_ACTIVITIES
507: where PROCESS_ITEM_TYPE = p_item_type
508: or ACTIVITY_ITEM_TYPE = p_item_type);
509:
510: delete from WF_ITEM_ACTIVITY_STATUSES
511: where PROCESS_ACTIVITY in
512: (select INSTANCE_ID from WF_PROCESS_ACTIVITIES
513: where PROCESS_ITEM_TYPE = p_item_type
514: or ACTIVITY_ITEM_TYPE = p_item_type);