The following lines contain the word 'select', 'insert', 'update' or 'delete':
select NAME
from WF_ROLE_LOV_VL
where DISPLAY_NAME = p_display_name
order by status, start_date;
** used the LOV to select the name and then blanked out the display
** name then make sure here to blank out the insternal name and return
*/
if (p_display_name is null) then
p_user_name := NULL;
** used the lov to select the name in which case the combination
** of the display name and the user name should be unique
*/
if (r_name_lov%ROWCOUNT > 1) then
close r_name_lov;
select count(1)
into l_names_count
from WF_ROLES
where NAME = p_user_name
and ORIG_SYSTEM not in ('HZ_PARTY','POS','ENG_LIST','AMV_CHN',
'HZ_GROUP','CUST_CONT')
and DISPLAY_NAME = p_display_name;
select count(1)
into l_names_count
from WF_ROLES
where NAME = p_user_name
and ORIG_SYSTEM = substr(p_user_name, 1, l_colon-1)
and ORIG_SYSTEM_ID = l_orig_system_id
and DISPLAY_NAME = p_display_name;