APPS.PQH_WF dependencies on WF_ITEMS

Line 134: FROM wf_items wfi

130: l_temp_holder VARCHAR2(1);
131: l_proc VARCHAR2(61) := g_package || 'wf_process_not_running ';
132: CURSOR c_wf IS
133: SELECT 'x'
134: FROM wf_items wfi
135: WHERE wfi.item_type = p_itemtype
136: AND wfi.item_key = p_itemkey;
137: BEGIN
138: hr_utility.set_location(l_proc || 'Entering',10);

Line 1463: WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS

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)
1467: and I.ITEM_TYPE = IT.NAME