DBA Data[Home] [Help]

APPS.OM_REPORTS_COMMON_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 11: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

7: BEGIN
8:
9: SELECT nvl(wfas.end_date,sysdate)
10: INTO ans_date
11: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
12: WHERE wfas.item_key = TO_CHAR(n_line_id) and
13: wfas.item_type = 'OEOL' and
14: wfas.process_activity = wpa.instance_id and
15: wpa.activity_item_type = 'OEOL' and