Line 16: -- Use either the supplied date, or the date from fnd_sessions
12: cached boolean := FALSE;
13: g_leg_code varchar2(2);
14: begin
15: -- 16: -- Use either the supplied date, or the date from fnd_sessions 17: --
18: if (p_effective_date is null) then
19: begin
20: select effective_date
Line 22: from fnd_sessions
18: if (p_effective_date is null) then
19: begin
20: select effective_date
21: into l_effective_date 22: from fnd_sessions 23: where session_id = userenv('sessionid');
24: end;
25: else
26: l_effective_date := p_effective_date;