APPS.HR_KFLEX_UTILITY dependencies on FND_SESSIONS

Line 329: select EFFECTIVE_DATE from fnd_sessions

325: -- start for fix of 3171225
326: l_effective_date date;
327:
328: cursor date_set is
329: select EFFECTIVE_DATE from fnd_sessions
330: where session_id=userenv('sessionid');
331: -- end for fix of 3171225
332: --
333: begin

Line 571: select EFFECTIVE_DATE from fnd_sessions

567: -- start for fix of 3171225
568: l_effective_date date;
569:
570: cursor date_set is
571: select EFFECTIVE_DATE from fnd_sessions
572: where session_id=userenv('sessionid');
573: -- end for fix of 3171225
574: --
575: -- Bug 3897294 Starts

Line 2295: select 1 from fnd_sessions

2291: ) is
2292: l_proc varchar2(72);
2293: --
2294: cursor date_set is
2295: select 1 from fnd_sessions
2296: where session_id=userenv('sessionid');
2297: --
2298: l_dummy number;
2299: begin

Line 2319: -- insert into fnd_sessions

2315: if g_debug then
2316: hr_utility.set_location(l_proc,30);
2317: end if;
2318: dt_fndate.set_effective_date(trunc(p_effective_Date));
2319: -- insert into fnd_sessions
2320: -- values
2321: -- (userenv('sessionid')
2322: -- ,trunc(p_effective_date));
2323: p_session_id:=userenv('sessionid');

Line 2351: delete from fnd_sessions

2347: if nvl(p_session_id,-1)<>-1 then
2348: if g_debug then
2349: hr_utility.set_location(l_proc,10);
2350: end if;
2351: delete from fnd_sessions
2352: where session_id=p_session_id;
2353: end if;
2354: --
2355: if g_debug then