APPS.HR_TRANSACTION_SS dependencies on WF_ROLES

Line 31: select name from wf_roles where UPPER(EMAIL_ADDRESS) = UPPER(substr (contextUser, 7)) and ORIG_SYSTEM = 'PER' and STATUS = 'ACTIVE';

27: l_user_role_count number default 0;
28: cursor username is
29: select user_id from fnd_user where user_name=contextUser;
30: cursor user_role_name is
31: select name from wf_roles where UPPER(EMAIL_ADDRESS) = UPPER(substr (contextUser, 7)) and ORIG_SYSTEM = 'PER' and STATUS = 'ACTIVE';
32: begin
33: if g_debug then
34: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
35: hr_utility.set_location('p_item_type:'||p_item_type,2);

Line 105: select count(name) into l_user_role_count from wf_roles where UPPER(EMAIL_ADDRESS) = UPPER(substr (contextUser, 7)) and ORIG_SYSTEM = 'PER' and STATUS = 'ACTIVE';

101: if((contextUser is not null) and (substr (contextUser, 1, 6) = 'email:')) then
102:
103: --check if only one PER role is attched with this Email address
104: begin
105: select count(name) into l_user_role_count from wf_roles where UPPER(EMAIL_ADDRESS) = UPPER(substr (contextUser, 7)) and ORIG_SYSTEM = 'PER' and STATUS = 'ACTIVE';
106: exception
107: when others then
108: null;
109: end;