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*/