APPS.ZPB_EXCEPTION_ALERT dependencies on WF_ITEMS_V

Line 910: from WF_ITEMS_V

906:
907:
908: CURSOR c_children is
909: select ITEM_KEY
910: from WF_ITEMS_V
911: where PARENT_ITEM_KEY = ParentItemKey;
912:
913: v_child c_children%ROWTYPE;
914:

Line 1582: from WF_ITEMS_V

1578:
1579:
1580: CURSOR c_children is
1581: select ITEM_KEY
1582: from WF_ITEMS_V
1583: where PARENT_ITEM_KEY = ParentItemKey;
1584:
1585: v_child c_children%ROWTYPE;
1586:

Line 1881: ITEM_KEY in (select ITEM_KEY from WF_ITEMS_V where PARENT_ITEM_KEY = ItemKey)

1877: -- ACTIVITY_STATUS_CODE is replaced by ACTIVITY_STATUS
1878: select count(*) into thisCount
1879: from WF_ITEM_ACTIVITY_STATUSES
1880: where ITEM_TYPE = 'EPBCYCLE' and
1881: ITEM_KEY in (select ITEM_KEY from WF_ITEMS_V where PARENT_ITEM_KEY = ItemKey)
1882: and (ACTIVITY_STATUS = 'NOTIFIED' or ACTIVITY_RESULT_CODE = '#TIMEOUT');
1883:
1884: if thisCount > 0 then
1885:

Line 1972: ITEM_KEY in (select ITEM_KEY from WF_ITEMS_V where PARENT_ITEM_KEY = ItemKey)

1968: CURSOR c_exceptionPool is
1969: SELECT ITEM_KEY, ASSIGNED_USER
1970: FROM WF_ITEM_ACTIVITY_STATUSES
1971: WHERE ITEM_TYPE = 'EPBCYCLE' and
1972: ITEM_KEY in (select ITEM_KEY from WF_ITEMS_V where PARENT_ITEM_KEY = ItemKey)
1973: and (ACTIVITY_STATUS = 'NOTIFIED' or ACTIVITY_RESULT_CODE = '#TIMEOUT');
1974: v_exChild c_exceptionPool%ROWTYPE;
1975:
1976: BEGIN

Line 2630: from WF_ITEMS_V

2626:
2627:
2628: CURSOR c_children is
2629: select ITEM_KEY
2630: from WF_ITEMS_V
2631: where PARENT_ITEM_KEY = ParentItemKey;
2632:
2633: v_child c_children%ROWTYPE;
2634:

Line 2824: from WF_ITEMS_V

2820:
2821:
2822: CURSOR c_children is
2823: select ITEM_KEY
2824: from WF_ITEMS_V
2825: where PARENT_ITEM_KEY = ParentItemKey;
2826:
2827: v_child c_children%ROWTYPE;
2828: