APPS.PAY_US_PTO_CO_PKG dependencies on FND_SESSIONS

Line 199: -- to fnd_sessions would not fail.

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

Line 236: from fnd_sessions

232: per_accrual_message_pkg.clear_table;
233:
234: begin
235: select effective_date into l_session_date
236: from fnd_sessions
237: where session_id = userenv('sessionid');
238: exception
239: when others then
240: select sysdate into l_session_date