APPS.POS_WCAPPROVE_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 1618: FROM wf_item_activity_statuses_v

1614: CURSOR c_group_id (p_itemtype VARCHAR2,
1615: p_itemkey VARCHAR2,
1616: p_activity_name VARCHAR2) IS
1617: SELECT notification_id
1618: FROM wf_item_activity_statuses_v
1619: WHERE item_type = p_itemtype
1620: AND item_key = p_itemkey
1621: AND activity_name = p_activity_name
1622: ORDER BY activity_end_date DESC;

Line 1714: FROM wf_item_activity_statuses_v

1710: CURSOR c_group_id (p_itemtype VARCHAR2,
1711: p_itemkey VARCHAR2,
1712: p_activity_name VARCHAR2) IS
1713: SELECT notification_id
1714: FROM wf_item_activity_statuses_v
1715: WHERE item_type = p_itemtype
1716: AND item_key = p_itemkey
1717: AND activity_name = p_activity_name
1718: ORDER BY activity_end_date DESC;

Line 1870: FROM wf_item_activity_statuses_v

1866: CURSOR c_group_id (p_itemtype VARCHAR2,
1867: p_itemkey VARCHAR2,
1868: p_activity_name VARCHAR2) IS
1869: SELECT notification_id
1870: FROM wf_item_activity_statuses_v
1871: WHERE item_type = p_itemtype
1872: AND item_key = p_itemkey
1873: AND activity_name = p_activity_name
1874: ORDER BY activity_end_date DESC;