APPS.OE_PUR_CONC_REQUESTS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 23: FROM wf_item_activity_statuses wias, wf_process_activities wpa

19: -- Check for workflow status to be Purchase Release Eligible
20:
21: SELECT wias.ACTIVITY_STATUS
22: INTO l_activity_status_code
23: FROM wf_item_activity_statuses wias, wf_process_activities wpa
24: WHERE wias.process_activity = wpa.instance_id
25: AND wpa.activity_name = 'PURCHASE RELEASE ELIGIBLE'
26: AND wias.item_type = 'OEOL'
27: AND wias.item_key = to_char(p_line_id)

Line 270: FROM wf_item_activity_statuses wias, wf_process_activities wpa

266: BEGIN
267:
268: SELECT wias.ACTIVITY_STATUS, wias.activity_result_code
269: INTO l_activity_status, l_activity_result
270: FROM wf_item_activity_statuses wias, wf_process_activities wpa
271: WHERE wias.process_activity = wpa.instance_id
272: AND wpa.activity_name = 'PUR_REL_THE_LINE'
273: AND wias.item_type = 'OEOL'
274: AND wias.item_key = to_char(v_line_id);