APPS.HRUSERDT dependencies on FND_SESSIONS

Line 43: -- Use either the supplied date, or the date from fnd_sessions

39: l_table_id pay_user_tables.user_table_id%type;
40: l_value pay_user_column_instances_f.value%type;
41: begin
42: --
43: -- Use either the supplied date, or the date from fnd_sessions
44: --
45: if (p_effective_date is null) then
46: if (g_effective_date is null) then
47: begin

Line 50: from fnd_sessions

46: if (g_effective_date is null) then
47: begin
48: select effective_date
49: into l_effective_date
50: from fnd_sessions
51: where session_id = userenv('sessionid');
52: end;
53: else
54: l_effective_date := g_effective_date;