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
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;
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: --