DBA Data[Home] [Help]

APPS.HR_JP_GENERAL_PKG dependencies on FND_SESSIONS

Line 11: from fnd_sessions

7: IS
8: l_effective_date DATE;
9: CURSOR cur_effective_date IS
10: select effective_date
11: from fnd_sessions
12: where session_id=userenv('sessionid');
13: BEGIN
14: open cur_effective_date;
15: fetch cur_effective_date into l_effective_date;

Line 144: from fnd_sessions

140: l_found VARCHAR2(5) := 'FALSE';
141:
142: CURSOR cur_effective_date IS
143: select effective_date
144: from fnd_sessions
145: where session_id=userenv('sessionid');
146: -- It doesn't matter whether action_status is 'C' or other values.
147: CURSOR cur_run_assact IS
148: select /*+ ORDERED USE_NL(PPA PES PTP) */