DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on WF_PROCESS_ACTIVITIES

Line 1615: FROM wf_item_activity_statuses wias, wf_process_activities wpa

1611:
1612: -- Bug 7688120
1613: SELECT wpa.activity_name -- Bug 10361575
1614: INTO l_activity
1615: FROM wf_item_activity_statuses wias, wf_process_activities wpa
1616: WHERE wias.item_type = 'OEOL'
1617: AND wias.item_key = To_Char(l_line_id)
1618: AND wias.process_activity = wpa.instance_id
1619: AND wias.activity_status = 'NOTIFIED';

Line 1797: FROM wf_item_activity_statuses wias, wf_process_activities wpa

1793: END IF;
1794:
1795: -- Bug 7688120
1796: SELECT wpa.instance_label INTO l_activity
1797: FROM wf_item_activity_statuses wias, wf_process_activities wpa
1798: WHERE wias.item_type = 'OEOL'
1799: AND wias.item_key = To_Char(l_line_id)
1800: AND wias.process_activity = wpa.instance_id
1801: AND wias.activity_status = 'NOTIFIED';