APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on FND_SESSIONS

Line 1731: from fnd_sessions ses

1727: cursor csr_year
1728: is
1729: --select to_char(ses.effective_date, 'YYYY'), ses.effective_date
1730: select to_char(sysdate,'YYYY'), ses.effective_date
1731: from fnd_sessions ses
1732: where ses.session_id = userenv('sessionid');
1733: begin
1734: open csr_year;
1735: fetch csr_year into l_year, l_effective_date;

Line 1882: from fnd_sessions

1878: l_effective_date date;
1879: begin
1880: begin
1881: select effective_date into l_effective_date
1882: from fnd_sessions
1883: where SESSION_ID = userenv('sessionid');
1884: exception
1885: when Others then
1886: l_effective_date := sysdate;