DBA Data[Home] [Help]

APPS.UMX_W3H_UTL dependencies on FND_USER

Line 96: from fnd_user where user_name = p_user_name;

92: l_assignment_end_date date;
93:
94: begin
95: select start_date,end_date into l_user_start_date,l_user_end_date
96: from fnd_user where user_name = p_user_name;
97:
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,