APPS.OE_2PC2_LINE_ECSUPDT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 21: FROM wf_item_activity_statuses w, wf_process_activities wpa

17: l_wf_activity_name varchar2(30) :='EXPORT_COMPLIANCE_SCREENING';
18: l_wf_activity_status_code varchar2(8) :='NOTIFIED';
19: CURSOR C_VC IS
20: SELECT count(*)
21: FROM wf_item_activity_statuses w, wf_process_activities wpa
22: WHERE w.item_type = l_wf_item_type
23: AND w.process_activity = wpa.instance_id
24: AND wpa.activity_name = l_wf_activity_name
25: AND w.activity_status = l_wf_activity_status_code