APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 48: from wf_item_activity_statuses wias,

44:
45:
46: select count(*)
47: into l_count
48: from wf_item_activity_statuses wias,
49: wf_process_activities wpa
50: where wias.item_type = 'OEOL'
51: and wias.item_key = to_char(p_line_id)
52: and wias.ACTIVITY_STATUS = 'NOTIFIED'

Line 1655: FROM wf_item_activity_statuses wias, wf_process_activities wpa

1651:
1652:
1653: SELECT 1
1654: INTO config_line_ship_notified
1655: FROM wf_item_activity_statuses wias, wf_process_activities wpa
1656: WHERE wias.item_type='OEOL'
1657: AND wias.item_key=to_char(l_config_line_id) -- Bug 14475080
1658: AND wpa.activity_name='SHIP_LINE'
1659: AND wias.activity_status='NOTIFIED'