APPS.HXT_TIME_CLOCK dependencies on FND_SESSIONS

Line 120: from fnd_sessions

116: --this to fix bug 756293
117: --
118: cursor C_session_exists is
119: select 'Y'
120: from fnd_sessions
121: where session_id = userenv('sessionid')
122: and trunc(effective_date) = trunc(sysdate);
123: --
124: --

Line 133: insert into fnd_sessions

129: -- fix for bug 756293
130: open C_session_exists;
131: fetch C_session_exists into l_exists;
132: if C_session_exists%notfound then
133: insert into fnd_sessions
134: (effective_date, session_id)
135: values (sysdate, userenv('sessionid'));
136: HXT_UTIL.DEBUG('Inserted a row in fnd session '); --HXT115
137: end if;