APPS.WF_EVENT_HTML dependencies on WF_RUNNABLE_PROCESSES_V

Line 5403: from WF_RUNNABLE_PROCESSES_V

5399: is
5400:
5401: cursor mycurs (c_find_criteria in varchar2) is
5402: select PROCESS_NAME, DISPLAY_NAME
5403: from WF_RUNNABLE_PROCESSES_V
5404: where PROCESS_NAME LIKE UPPER(c_find_criteria)||'%'
5405: and ITEM_TYPE = p_param1
5406: order by PROCESS_NAME;
5407:

Line 5428: from WF_RUNNABLE_PROCESSES_V

5424: ** criteria before actually executing the fetch to show the user
5425: ** how many matches are available.
5426: */
5427: select count(*) into l_total_rows
5428: from WF_RUNNABLE_PROCESSES_V
5429: where PROCESS_NAME like upper(p_display_value)||'%'
5430: and ITEM_TYPE = p_param1;
5431:
5432: wf_lov.g_define_rec.total_rows := l_total_rows;

Line 5455: from WF_RUNNABLE_PROCESSES_V

5451:
5452: elsif (p_mode = 'GET_DISPLAY_VAL') THEN
5453: select PROCESS_NAME, DISPLAY_NAME
5454: into l_name, l_display_name
5455: from WF_RUNNABLE_PROCESSES_V
5456: where PROCESS_NAME = upper(p_display_value)
5457: and ITEM_TYPE = p_param1;
5458:
5459: p_display_value := l_name;

Line 5500: from WF_RUNNABLE_PROCESSES_V

5496: if (ii = 2) then
5497:
5498: select count(*)
5499: into ii
5500: from WF_RUNNABLE_PROCESSES_V
5501: where PROCESS_NAME = p_display_value
5502: and ITEM_TYPE = p_param1;
5503:
5504: end if;