DBA Data[Home] [Help]

APPS.PAY_AU_PAYTAX_PKG dependencies on FND_SESSIONS

Line 150: FROM fnd_sessions

146: ;
147: /*bug7280733*/
148: cursor c_session is
149: SELECT 'X' INTO l_session_flag
150: FROM fnd_sessions
151: WHERE session_id = USERENV('SESSIONID');
152:
153: BEGIN
154:

Line 181: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE) values (userenv('sessionid'),trunc(p_start_date));

177: IF c_formula%FOUND THEN
178: OPEN c_session;
179: FETCH c_session into l_session_flag;
180: IF c_session%NOTFOUND THEN
181: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE) values (userenv('sessionid'),trunc(p_start_date));
182: END IF;
183: CLOSE c_session;
184: END IF;
185: /* bug7280733 end*/