APPS.ENG_WORKFLOW_API_PKG dependencies on WF_ITEMS

Line 38: FROM WF_ITEMS

34: BEGIN
35: /* Find User's User Name */
36: SELECT owner_role
37: INTO x_item_owner_role
38: FROM WF_ITEMS
39: WHERE item_type = itemtype
40: AND item_key = itemkey ;
41:
42: Return x_item_owner_role;

Line 1423: wf_items wfi where wfl.lookup_type = wfa.result_type

1419: select wfl.lookup_code result_code
1420: from wf_lookups wfl,
1421: wf_activities wfa,
1422: wf_process_activities wfpa,
1423: wf_items wfi where wfl.lookup_type = wfa.result_type
1424: and wfa.name = wfpa.activity_name
1425: and wfi.begin_date >= wfa.begin_date
1426: and wfi.begin_date < nvl(wfa.end_date,wfi.begin_date+1)
1427: and wfpa.activity_item_type = wfa.item_type