DBA Data[Home] [Help]

APPS.PQH_WF dependencies on WF_PROCESS_ACTIVITIES

Line 1462: from WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,

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
1466: and I.BEGIN_DATE between A.BEGIN_DATE and nvl(A.END_DATE, I.BEGIN_DATE)