APPS.PA_AUTOALLOC_UTLS dependencies on WF_ITEMS_V

Line 49: FROM WF_Items_V WF

45: v_item_key Varchar2(15);
46:
47: Cursor SetCur IS
48: SELECT WF.End_Date
49: FROM WF_Items_V WF
50: WHERE WF.Item_Type = 'GLALLOC'
51: AND WF.Item_Key = v_item_key
52: AND WF.root_activity = 'GL_SD_ALLOCATION_PROCESS';
53:

Line 67: then find the end date recorded in wf_items_v for the item_type,item_key

63:
64: Else
65:
66: /*If the run belongs to an autoallocation set that has started a workflow
67: then find the end date recorded in wf_items_v for the item_type,item_key
68: and root_activity.If it's complete then end_date will be not null*/
69:
70: Open SetCur;
71: Fetch SetCur into v_end_date;