APPS.UMX_W3H_UTL dependencies on WF_USER_ROLE_ASSIGNMENTS

Line 102: from wf_user_role_assignments

98: select min(role_start_date) ,max(nvl(role_end_date,to_date('31-12-9999','DD-MM-YYYY'))),min(effective_start_date),
99: max(nvl(effective_end_date,to_date('31-12-9999','DD-MM-YYYY'))),min( start_date),max(nvl(end_date,to_date('31-12-9999','DD-MM-YYYY')))
100: into l_role_start_date,l_role_end_date,l_effective_start_date,l_effective_end_date,
101: l_assignment_start_date,l_assignment_end_date
102: from wf_user_role_assignments
103: where user_name=p_user_name and role_name = p_role_name;
104:
105: -- check whether user is inactive
106: if(l_user_start_date > sysdate or l_user_end_date <= sysdate) then