APPS.OE_SHIP_CONFIRMATION_PUB dependencies on WF_PROCESS_ACTIVITIES

Line 5539: from wf_item_activity_statuses wias, wf_process_activities wpa

5535: --END IF;
5536: l_count := 0;
5537: select Count (1)
5538: INTO l_count
5539: from wf_item_activity_statuses wias, wf_process_activities wpa
5540: where wias.process_activity = wpa.instance_id
5541: and to_number(wias.item_key) = p_line_id
5542: and wias.item_type = 'OEOL'
5543: AND wpa.activity_item_type = wias.item_type