DBA Data[Home] [Help]

APPS.PQH_WF dependencies on WF_DIRECTORY

Line 1461: wf_directory.getroledisplayname(IAS.ASSIGNED_USER) role_name ,IAS.ASSIGNED_USER owner

1457: function get_notification_detail(p_itemkey in varchar2,
1458: p_mode in varchar2) return varchar2 is
1459: cursor c1 is
1460: SELECT A.NAME activity_name,
1461: wf_directory.getroledisplayname(IAS.ASSIGNED_USER) role_name ,IAS.ASSIGNED_USER owner
1462: from WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,
1463: WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS
1464: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1465: and IAS.ITEM_KEY = I.ITEM_KEY