DBA Data[Home] [Help]

APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on FND_SESSIONS

Line 99: /* Use either the supplied date, or the date from fnd_sessions */

95: and l_effective_date
96: between puci.effective_start_date and puci.effective_end_date;
97: BEGIN
98: --
99: /* Use either the supplied date, or the date from fnd_sessions */
100: if p_effective_date is null then
101: select effective_date
102: into l_effective_date
103: from fnd_sessions

Line 103: from fnd_sessions

99: /* Use either the supplied date, or the date from fnd_sessions */
100: if p_effective_date is null then
101: select effective_date
102: into l_effective_date
103: from fnd_sessions
104: where session_id = userenv('sessionid');
105: else
106: l_effective_date := p_effective_date;
107: end if;

Line 281: from fnd_sessions

277: g_session_id := userenv('sessionid');
278: --
279: select effective_date
280: into g_effective_date
281: from fnd_sessions
282: where session_id = g_session_id;
283: --
284: l_effective_date := g_effective_date;
285: --