APPS.POS_WCAPPROVE_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

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;

Line 2437: wf_item_activity_statuses wias

2433: l_progress := 'POS_WCAPPROVE_PVT.Update_Action_history: 02.';
2434: SELECT nvl(max(wf.notification_id), -9995)
2435: into l_notification_id
2436: FROM wf_notifications wf,
2437: wf_item_activity_statuses wias
2438: WHERE wias.item_type = p_itemtype
2439: and wias.item_key = p_itemkey
2440: and wias.notification_id = wf.group_id;
2441:

Line 4969: from wf_item_activity_statuses ias,

4965: END IF;
4966: update wf_notifications set status = 'CLOSED'
4967: where notification_id in (
4968: select ias.notification_id
4969: from wf_item_activity_statuses ias,
4970: wf_notifications ntf
4971: where ias.item_type = p_itemtype
4972: and ias.item_key = p_itemkey
4973: and ntf.notification_id = ias.notification_id);