APPS.POS_WCAPPROVE_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

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;

Line 2436: wf_item_activity_statuses wias

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

Line 4642: from wf_item_activity_statuses ias,

4638: END IF;
4639: update wf_notifications set status = 'CLOSED'
4640: where notification_id in (
4641: select ias.notification_id
4642: from wf_item_activity_statuses ias,
4643: wf_notifications ntf
4644: where ias.item_type = p_itemtype
4645: and ias.item_key = p_itemkey
4646: and ntf.notification_id = ias.notification_id);