DBA Data[Home] [Help]

APPS.PEFRUSDT dependencies on FND_SESSIONS

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;