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 1273: wf_items wfi where wfl.lookup_type = wfa.result_type

1269: select wfl.lookup_code result_code
1270: from wf_lookups wfl,
1271: wf_activities wfa,
1272: wf_process_activities wfpa,
1273: wf_items wfi where wfl.lookup_type = wfa.result_type
1274: and wfa.name = wfpa.activity_name
1275: and wfi.begin_date >= wfa.begin_date
1276: and wfi.begin_date < nvl(wfa.end_date,wfi.begin_date+1)
1277: and wfpa.activity_item_type = wfa.item_type