DBA Data[Home] [Help]

APPS.PO_APPROVAL_LIST_WF1S dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 1791: FROM wf_item_activity_statuses_v

1787: funcmode in varchar2,
1788: resultout out NOCOPY varchar2) IS
1789: CURSOR c_group_id (p_itemtype VARCHAR2, p_itemkey VARCHAR2, p_activity_name VARCHAR2) IS
1790: SELECT notification_id
1791: FROM wf_item_activity_statuses_v
1792: WHERE item_type = p_itemtype
1793: AND item_key = p_itemkey
1794: AND activity_name = p_activity_name
1795: ORDER BY activity_end_date DESC;

Line 2353: FROM wf_item_activity_statuses_v

2349: forwardToId out NOCOPY number) is
2350:
2351: CURSOR c_group_id (p_itemtype VARCHAR2, p_itemkey VARCHAR2, p_activity_name VARCHAR2, p_activity_name2 VARCHAR2, p_activity_name3 VARCHAR2, p_activity_name4 VARCHAR2) IS
2352: SELECT notification_id
2353: FROM wf_item_activity_statuses_v
2354: WHERE item_type = p_itemtype
2355: AND item_key = p_itemkey
2356: AND activity_name in ( p_activity_name, p_activity_name2,
2357: p_activity_name3, p_activity_name4)