APPS.POS_WCAPPROVE_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 1617: FROM wf_item_activity_statuses_v

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

Line 1713: FROM wf_item_activity_statuses_v

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

Line 1869: FROM wf_item_activity_statuses_v

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