DBA Data[Home] [Help]

APPS.PO_APPROVAL_REMINDER_SV dependencies on WF_ITEMS_V

Line 2805: from wf_item_activity_statuses_v wias, wf_items_v wi

2801: --we want to make sure that the reminder notification with new item key
2802: --is aborted correctly.
2803: Cursor cand_active_wf(l_itemkey VARCHAR2) IS
2804: select wias.activity_status_code, wias.item_key
2805: from wf_item_activity_statuses_v wias, wf_items_v wi
2806: where wias.item_type = 'APVRMDER'
2807: and wias.item_key like l_itemkey||'%'
2808: and wias.item_type = wi.item_type
2809: and wias.item_key = wi.item_key

Line 3144: FROM WF_ITEMS_V WI

3140: p_item_end_date := NULL;
3141:
3142: SELECT 'Y', WI.end_date
3143: INTO p_item_exist, p_item_end_date
3144: FROM WF_ITEMS_V WI
3145: WHERE WI.ITEM_TYPE = p_ItemType
3146: AND WI.ITEM_KEY = p_ItemKey;
3147:
3148: