APPS.WF_FWKMON dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 107: FROM wf_item_activity_statuses wias,

103:
104: CURSOR get_root_info IS
105: SELECT wias.activity_result_code,
106: wias.activity_status
107: FROM wf_item_activity_statuses wias,
108: wf_activities wa,
109: wf_process_activities wpa
110: WHERE wias.item_key = x_itemKey
111: AND wias.item_type = x_itemType

Line 131: FROM wf_item_activity_statuses

127: -- single row existence here. 13-NOV-01
128:
129: SELECT 1
130: INTO error_count
131: FROM wf_item_activity_statuses
132: WHERE item_type = x_itemType
133: AND item_key = x_itemKey
134: AND activity_status = 'ERROR'
135: AND rownum = 1;