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 570: select EFFECTIVE_DATE from fnd_sessions

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

Line 2280: select 1 from fnd_sessions

2276: ) is
2277: l_proc varchar2(72);
2278: --
2279: cursor date_set is
2280: select 1 from fnd_sessions
2281: where session_id=userenv('sessionid');
2282: --
2283: l_dummy number;
2284: begin

Line 2304: -- insert into fnd_sessions

2300: if g_debug then
2301: hr_utility.set_location(l_proc,30);
2302: end if;
2303: dt_fndate.set_effective_date(trunc(p_effective_Date));
2304: -- insert into fnd_sessions
2305: -- values
2306: -- (userenv('sessionid')
2307: -- ,trunc(p_effective_date));
2308: p_session_id:=userenv('sessionid');

Line 2336: delete from fnd_sessions

2332: if nvl(p_session_id,-1)<>-1 then
2333: if g_debug then
2334: hr_utility.set_location(l_proc,10);
2335: end if;
2336: delete from fnd_sessions
2337: where session_id=p_session_id;
2338: end if;
2339: --
2340: if g_debug then