DBA Data[Home] [Help]

APPS.PAY_KR_BEE_UPLOAD dependencies on FND_SESSIONS

Line 89: from fnd_sessions

85: l_leg_code varchar2(2);
86:
87: cursor csr_get_eff_date is
88: select effective_date
89: from fnd_sessions
90: where session_id = userenv('sessionid');
91:
92: cursor csr_get_leg_code is
93: select legislation_code

Line 139: -- Use either the supplied date, or the date from fnd_sessions

135: l_leg_code) = l_leg_code;
136: --
137: begin
138: --
139: -- Use either the supplied date, or the date from fnd_sessions
140: --
141: if (p_effective_date is null) then
142: open csr_get_eff_date ;
143: fetch csr_get_eff_date into l_effective_date;