APPS.PO_APPROVAL_REMINDER_SV dependencies on WF_ITEMS

Line 2839: from wf_item_activity_statuses_v wias, wf_items_v wi

2835: --we want to make sure that the reminder notification with new item key
2836: --is aborted correctly.
2837: Cursor cand_active_wf(l_itemkey VARCHAR2) IS
2838: select wias.activity_status_code, wias.item_key
2839: from wf_item_activity_statuses_v wias, wf_items_v wi
2840: where wias.item_type = 'APVRMDER'
2841: and wias.item_key like l_itemkey||'%'
2842: and wias.item_type = wi.item_type
2843: and wias.item_key = wi.item_key

Line 3178: FROM WF_ITEMS_V WI

3174: p_item_end_date := NULL;
3175:
3176: SELECT 'Y', WI.end_date
3177: INTO p_item_exist, p_item_end_date
3178: FROM WF_ITEMS_V WI
3179: WHERE WI.ITEM_TYPE = p_ItemType
3180: AND WI.ITEM_KEY = p_ItemKey;
3181:
3182:

Line 3444: l_item_key WF_ITEMS.item_key%TYPE;

3440: p_expiration_date IN DATE
3441: ) IS
3442: l_proc_name CONSTANT VARCHAR2(30) := 'start_po_line_reminder_wf';
3443:
3444: l_item_key WF_ITEMS.item_key%TYPE;
3445: l_item_exist VARCHAR2(1);
3446: l_item_end_date DATE;
3447: l_requester_user_name WF_USERS.name%TYPE;
3448: l_requester_disp_name WF_USERS.display_name%TYPE;