APPS.WFA_HTML dependencies on WF_ROLES

Line 1482: -- problem with this query against wf_roles.

1478: --
1479: -- User_LOV
1480: -- Create the data for the User List of Values
1481: -- NOTE: This is not used by APPS. Otherwise, we will have performance
1482: -- problem with this query against wf_roles.
1483: --
1484: procedure User_LOV (p_titles_only IN VARCHAR2,
1485: p_find_criteria IN VARCHAR2)
1486:

Line 1773: -- from wf_roles

1769: -- roles display
1770:
1771: -- CURSOR c_user_display_value (c_name IN VARCHAR2) IS
1772: -- select name, display_name
1773: -- from wf_roles
1774: -- where name = c_name;
1775:
1776: ii NUMBER := 0;
1777: nn NUMBER := 0;

Line 1881: from WF_ROLES

1877: colon := instr(p_display_value,':');
1878: if (colon = 0) then
1879: select count(*)
1880: into ii
1881: from WF_ROLES
1882: where NAME = p_display_value
1883: and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
1884: 'HZ_GROUP','CUST_CONT');
1885: else

Line 1888: from WF_ROLES

1884: 'HZ_GROUP','CUST_CONT');
1885: else
1886: select count(*)
1887: into ii
1888: from WF_ROLES
1889: where NAME = p_display_value
1890: and ORIG_SYSTEM = substr(p_display_value, 1, colon-1)
1891: and ORIG_SYSTEM_ID = substr(p_display_value, colon+1);
1892: end if;

Line 2050: from WF_ROLES

2046:
2047: if (l_colon = 0) then
2048: select count(1)
2049: into l_names_count
2050: from WF_ROLES
2051: where NAME = p_user_name
2052: and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
2053: 'HZ_GROUP','CUST_CONT')
2054: and DISPLAY_NAME = p_display_name;

Line 2070: from WF_ROLES

2066: raise;
2067: end;
2068: select count(1)
2069: into l_names_count
2070: from WF_ROLES
2071: where NAME = p_user_name
2072: and ORIG_SYSTEM = substr(p_user_name, 1, l_colon-1)
2073: and ORIG_SYSTEM_ID = l_orig_system_id
2074: and DISPLAY_NAME = p_display_name;