APPS.OE_HOLDS_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 132: FROM WF_ITEM_ACTIVITY_STATUSES IAS,

128: -- Retrieving internal name and itemtype of the parent process.
129:
130: SELECT PARENT.ACTIVITY_ITEM_TYPE, PARENT.ACTIVITY_NAME
131: INTO l_wf_item, l_wf_activity
132: FROM WF_ITEM_ACTIVITY_STATUSES IAS,
133: WF_PROCESS_ACTIVITIES CHILD,
134: WF_PROCESS_ACTIVITIES PARENT
135: WHERE CHILD.INSTANCE_ID = actid
136: AND CHILD.PROCESS_ITEM_TYPE = PARENT.ACTIVITY_ITEM_TYPE