APPS.AME_ACA_SHD dependencies on AME_UTIL

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

57: from ame_calling_apps
58: where application_id = p_application_id
59: and p_effective_date
60: between start_date
61: and nvl(end_date - ame_util.oneSecond,p_effective_date);
62: --
63: l_fct_ret boolean;
64: --
65: Begin

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

149: ,t.last_update_login = l_current_user_id
150: , t.object_version_number = l_object_version_number
151: where t.application_id = p_application_id
152: and p_effective_date
153: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
154: ;
155: --
156: --
157: p_object_version_number := l_object_version_number;

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

192: ,object_version_number
193: from ame_calling_apps
194: where application_id = p_application_id
195: and p_effective_date
196: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
197: for update nowait;
198: --
199: --
200: --