APPS.WFA_HTML dependencies on WF_ROLE_LOV_VL

Line 3888: FROM wf_role_lov_vl

3884: CURSOR c_user_lov (c_find_criteria IN VARCHAR2) IS
3885: SELECT
3886: name,
3887: display_name
3888: FROM wf_role_lov_vl
3889: where status <> 'INACTIVE'
3890: and (UPPER(display_name) LIKE UPPER(c_find_criteria)||'%')
3891: order by display_name;
3892:

Line 3924: FROM wf_role_lov_vl

3920: ** how many matches are available.
3921: */
3922: select count(*)
3923: into l_total_rows
3924: FROM wf_role_lov_vl
3925: where status <> 'INACTIVE'
3926: and (UPPER(display_name) LIKE UPPER(p_display_value)||'%');
3927:
3928: wf_lov.g_define_rec.total_rows := l_total_rows;

Line 4137: from wf_role_lov_vl

4133: ** Check out how many names match the display name
4134: */
4135: select count(1)
4136: into l_names_count
4137: from wf_role_lov_vl
4138: where display_name = p_display_name;
4139:
4140: /*
4141: ** If there are no matches for the display name then raise an error

Line 4157: from wf_role_lov_vl

4153: elsif (l_names_count = 1) then
4154:
4155: select name
4156: into l_name
4157: from wf_role_lov_vl
4158: where display_name = p_display_name;
4159:
4160: p_user_name := l_name;
4161: