APPS.WFA_HTML dependencies on WF_ROLE_LOV_VL

Line 1763: FROM wf_role_lov_vl

1759: CURSOR c_user_lov (c_find_criteria IN VARCHAR2) IS
1760: SELECT
1761: name,
1762: display_name
1763: FROM wf_role_lov_vl
1764: where status <> 'INACTIVE'
1765: and (UPPER(display_name) LIKE UPPER(c_find_criteria)||'%')
1766: order by display_name;
1767:

Line 1799: FROM wf_role_lov_vl

1795: ** how many matches are available.
1796: */
1797: select count(*)
1798: into l_total_rows
1799: FROM wf_role_lov_vl
1800: where status <> 'INACTIVE'
1801: and (UPPER(display_name) LIKE UPPER(p_display_value)||'%');
1802:
1803: wf_lov.g_define_rec.total_rows := l_total_rows;

Line 2012: from wf_role_lov_vl

2008: ** Check out how many names match the display name
2009: */
2010: select count(1)
2011: into l_names_count
2012: from wf_role_lov_vl
2013: where display_name = p_display_name;
2014:
2015: /*
2016: ** If there are no matches for the display name then raise an error

Line 2032: from wf_role_lov_vl

2028: elsif (l_names_count = 1) then
2029:
2030: select name
2031: into l_name
2032: from wf_role_lov_vl
2033: where display_name = p_display_name;
2034:
2035: p_user_name := l_name;
2036: