APPS.OE_SHIP_CONFIRMATION_PUB dependencies on WF_PROCESS_ACTIVITIES

Line 5159: from wf_item_activity_statuses wias, wf_process_activities wpa

5155: --END IF;
5156: l_count := 0;
5157: select Count (1)
5158: INTO l_count
5159: from wf_item_activity_statuses wias, wf_process_activities wpa
5160: where wias.process_activity = wpa.instance_id
5161: and to_number(wias.item_key) = p_line_id
5162: and wias.item_type = 'OEOL'
5163: AND wpa.activity_item_type = wias.item_type