DBA Data[Home] [Help]

APPS.WF_ITEM_DEFINITION dependencies on WF_ITEMS

Line 61: FROM wf_item_types_vl wit, wf_items wik

57: ** List of item types based on owner access for a given user.
58: */
59: CURSOR user_itemtypes IS
60: SELECT distinct wit.display_name, wit.name
61: FROM wf_item_types_vl wit, wf_items wik
62: WHERE wik.owner_role = l_username
63: AND wik.item_type = wit.name
64: ORDER BY 1;
65:

Line 68: FROM wf_items wik

64: ORDER BY 1;
65:
66: CURSOR all_users IS
67: SELECT distinct wik.owner_role owner_role
68: FROM wf_items wik
69: ORDER BY 1;
70:
71: BEGIN
72: