Line 47: If nvl(trunc(l_effective_date),hr_api.g_date) <> p_effective_date then
43: end loop;
44:
45: If l_exists then
46: 47: If nvl(trunc(l_effective_date),hr_api.g_date) <> p_effective_date then 48: update fnd_sessions
49: set effective_date = p_effective_date
50: where session_id = l_session_id;
51: End if;