APPS.GHR_FORMULA_FUNCTIONS dependencies on FND_SESSIONS

Line 347: l_session_date fnd_sessions.effective_date%type;

343: RETURN varchar2 is
344: l_procedure_name varchar2(100);
345: l_person_type per_person_types.system_person_type%type;
346: l_person_id per_people_f.person_id%type;
347: l_session_date fnd_sessions.effective_date%type;
348: cursor c_get_session_date is
349: select trunc(effective_date) session_date
350: from fnd_sessions
351: where session_id = (select userenv('sessionid') from dual);

Line 350: from fnd_sessions

346: l_person_id per_people_f.person_id%type;
347: l_session_date fnd_sessions.effective_date%type;
348: cursor c_get_session_date is
349: select trunc(effective_date) session_date
350: from fnd_sessions
351: where session_id = (select userenv('sessionid') from dual);
352: cursor c_per_id is
353: select person_id from
354: per_assignments_f

Line 2281: from fnd_sessions

2277:
2278:
2279: cursor c_get_eff_st_dt is
2280: select trunc(effective_date) session_date
2281: from fnd_sessions
2282: where session_id = (select userenv('sessionid') from dual);
2283:
2284:
2285: -- get hire date