APPS.PO_APPROVAL_REMINDER_SV dependencies on WF_ITEMS

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:

Line 3410: l_item_key WF_ITEMS.item_key%TYPE;

3406: p_expiration_date IN DATE
3407: ) IS
3408: l_proc_name CONSTANT VARCHAR2(30) := 'start_po_line_reminder_wf';
3409:
3410: l_item_key WF_ITEMS.item_key%TYPE;
3411: l_item_exist VARCHAR2(1);
3412: l_item_end_date DATE;
3413: l_requester_user_name WF_USERS.name%TYPE;
3414: l_requester_disp_name WF_USERS.display_name%TYPE;