APPS.AME_ACT_SHD dependencies on AME_UTIL

Line 62: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date);

58: from ame_actions
59: where action_id = p_action_id
60: and action_type_id = p_action_type_id
61: and p_effective_date
62: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date);
63: --
64: l_fct_ret boolean;
65: --
66: Begin

Line 159: and nvl(t.end_date - ame_util.oneSecond,sysdate);

155: ,t.object_version_number = l_object_version_number
156: where t.action_id = p_action_id
157: and t.action_type_id = p_action_type_id
158: and p_effective_date between t.start_date
159: and nvl(t.end_date - ame_util.oneSecond,sysdate);
160: --
161: --
162: p_object_version_number := l_object_version_number;
163: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 203: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)

199: from ame_actions
200: where action_id = p_action_id
201: and action_type_id = p_action_type_id
202: and p_effective_date
203: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)
204: for update nowait;
205: --
206: --
207: --