DBA Data[Home] [Help]

APPS.PER_IN_CON_LEG_HOOK dependencies on FND_SESSIONS

Line 228: SELECT effective_date into l_current_date from fnd_sessions

224: ---Get the age of nominee--
225: pay_in_utils.set_location(g_debug,l_procedure,50);
226: If p_information_type = 'IN_NOMINATION_DETAILS' then
227: BEGIN
228: SELECT effective_date into l_current_date from fnd_sessions
229: WHERE session_id = userenv('SESSIONID');
230: EXCEPTION
231: WHEN NO_DATA_FOUND THEN
232: l_current_date := trunc(sysdate);