APPS.WF_EVENT_HTML dependencies on WF_ITEM_TYPES_VL

Line 3227: from WF_ITEM_TYPES_VL

3223: if (l_wfptype is not null) then
3224: begin
3225: select DISPLAY_NAME
3226: into l_wfptype_dname
3227: from WF_ITEM_TYPES_VL
3228: where NAME = l_wfptype;
3229:
3230: exception
3231: when NO_DATA_FOUND then

Line 5270: from WF_ITEM_TYPES_VL

5266: is
5267:
5268: cursor mycurs (c_find_criteria in varchar2) is
5269: select NAME, DISPLAY_NAME
5270: from WF_ITEM_TYPES_VL
5271: where (UPPER(DISPLAY_NAME) LIKE UPPER(c_find_criteria)||'%'
5272: or
5273: NAME LIKE UPPER(c_find_criteria)||'%')
5274: and NAME not in ('WFSTD','WFMAIL', 'SYSERROR')

Line 5294: from WF_ITEM_TYPES_VL

5290: ** criteria before actually executing the fetch to show the user
5291: ** how many matches are available.
5292: */
5293: select count(*) into l_total_rows
5294: from WF_ITEM_TYPES_VL
5295: where (upper(DISPLAY_NAME) like upper(p_display_value)||'%'
5296: or
5297: NAME like upper(p_display_value)||'%')
5298: and NAME not in ('WFSTD', 'WFERROR', 'WFMAIL', 'SYSERROR');

Line 5323: from WF_ITEM_TYPES_VL

5319:
5320: elsif (p_mode = 'GET_DISPLAY_VAL') THEN
5321: select NAME, DISPLAY_NAME
5322: into l_name, l_display_name
5323: from WF_ITEM_TYPES_VL
5324: where upper(DISPLAY_NAME) = upper(p_hidden_value);
5325:
5326: p_display_value := l_name;
5327:

Line 5367: from WF_ITEM_TYPES_VL

5363: if (ii = 2) then
5364:
5365: select count(*)
5366: into ii
5367: from WF_ITEM_TYPES_VL
5368: where NAME = p_display_value;
5369:
5370: end if;
5371: