APPS.OE_5PC1_ORDER_RETREJA dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 22: FROM wf_item_activity_statuses w, wf_process_activities wpa

18: l_wf_activity_status_code varchar2(8) :='COMPLETE';
19: l_wf_activity_result_code varchar2(30) :='REJECTED';
20: CURSOR C_VC IS
21: SELECT count(*)
22: FROM wf_item_activity_statuses w, wf_process_activities wpa
23: ,OE_AK_ORDER_HEADERS_V a
24: WHERE w.item_type = l_wf_item_type
25: AND w.process_activity = wpa.instance_id
26: AND wpa.activity_name = l_wf_activity_name