APPS.PAY_JP_FORMULA_FUNCTION_PKG dependencies on FND_SESSIONS

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

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

Line 99: from fnd_sessions

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