APPS.OE_SCH_FIRM_CONC dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 20: FROM wf_item_activity_statuses wias, wf_process_activities wpa

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

Line 81: From wf_item_activity_statuses wias, wf_process_activities wpa,

77:
78: -- Moac Changed below cursor to join to oe_order_lines table
79: CURSOR wf_item IS
80: Select item_key, l.org_id
81: From wf_item_activity_statuses wias, wf_process_activities wpa,
82: oe_order_lines l
83: Where wias.item_type = 'OEOL'
84: And wias.process_activity = wpa.instance_id
85: And wpa.activity_item_type = 'OEOL'