DBA Data[Home] [Help]

APPS.PAY_US_PTO_CO_PKG dependencies on FND_SESSIONS

Line 195: -- to fnd_sessions would not fail.

191: --
192: -- Fix for bug 3434710 starts here.
193: -- As this procedure is called from concurrent request, a row in fnd_session
194: -- should be inserted sothat the fastformula databse item SQL's which are having joins
195: -- to fnd_sessions would not fail.
196: --
197: dt_fndate.set_effective_date
198: (p_effective_date => trunc(sysdate)
199: ,p_do_commit => true

Line 232: from fnd_sessions

228: per_accrual_message_pkg.clear_table;
229:
230: begin
231: select effective_date into l_session_date
232: from fnd_sessions
233: where session_id = userenv('sessionid');
234: exception
235: when others then
236: select sysdate into l_session_date