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;
Line 98: If nvl(trunc(l_effective_date),hr_api.g_date) <> p_effective_date then
94: end loop;
95:
96: If l_exists then
97: 98: If nvl(trunc(l_effective_date),hr_api.g_date) <> p_effective_date then 99: update fnd_sessions
100: set effective_date = p_effective_date
101: where session_id = l_session_id;
102: End if;