APPS.PAY_PAYGBSOE_XMLP_PKG dependencies on FND_SESSIONS

Line 47: insert into fnd_sessions (session_id, effective_date)

43: open csr_session_date;
44: fetch csr_session_date into l_session_date;
45: close csr_session_date;
46:
47: insert into fnd_sessions (session_id, effective_date)
48: select userenv('sessionid'), trunc(l_session_date)
49: from dual
50: where not exists
51: (select 1

Line 52: from fnd_sessions fs

48: select userenv('sessionid'), trunc(l_session_date)
49: from dual
50: where not exists
51: (select 1
52: from fnd_sessions fs
53: where fs.session_id = userenv('sessionid'));
54: select session_id
55: into l_test
56: from fnd_sessions

Line 56: from fnd_sessions

52: from fnd_sessions fs
53: where fs.session_id = userenv('sessionid'));
54: select session_id
55: into l_test
56: from fnd_sessions
57: where session_id = userenv('sessionid');
58: exception
59: when no_data_found then
60: null;