APPS.AME_CON_SHD dependencies on AME_UTIL

Line 65: and nvl(end_date - ame_util.oneSecond,p_effective_date);

61: from ame_conditions
62: where condition_id = p_condition_id
63: and p_effective_date
64: between start_date
65: and nvl(end_date - ame_util.oneSecond,p_effective_date);
66: --
67: l_fct_ret boolean;
68: --
69: Begin

Line 157: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)

153: ,t.last_update_login = l_current_user_id
154: , t.object_version_number = l_object_version_number
155: where t.condition_id = p_condition_id
156: and p_effective_date
157: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
158: ;
159: --
160: --
161: p_object_version_number := l_object_version_number;

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

200: ,object_version_number
201: from ame_conditions
202: where condition_id = p_condition_id
203: and p_effective_date
204: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
205: for update nowait;
206: --
207: --
208: --