APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on FND_SESSIONS

Line 2183: from fnd_sessions ses

2179: cursor csr_year
2180: is
2181: --select to_char(ses.effective_date, 'YYYY'), ses.effective_date
2182: select to_char(sysdate,'YYYY'), ses.effective_date
2183: from fnd_sessions ses
2184: where ses.session_id = userenv('sessionid');
2185: begin
2186: open csr_year;
2187: fetch csr_year into l_year, l_effective_date;

Line 2334: from fnd_sessions

2330: l_effective_date date;
2331: begin
2332: begin
2333: select effective_date into l_effective_date
2334: from fnd_sessions
2335: where SESSION_ID = userenv('sessionid');
2336: exception
2337: when Others then
2338: l_effective_date := sysdate;