APPS.AME_ACA_BUS dependencies on AME_UTIL

Line 111: and nvl(end_date - ame_util.oneSecond, p_effective_date);*/

107: from ame_calling_apps
108: where application_name=p_application_name;
109: -- Modified for 4540774.
110: /* and p_effective_date between start_date
111: and nvl(end_date - ame_util.oneSecond, p_effective_date);*/
112: l_proc varchar2(72) := g_package || 'CHK_APPLICATION_NAME';
113: l_key varchar2(1);
114: --
115: Begin

Line 280: select ame_utility_pkg.is_seed_user(created_by)

276: ,p_effective_date in date
277: ) IS
278: --
279: cursor csr_isSeeded is
280: select ame_utility_pkg.is_seed_user(created_by)
281: from ame_calling_apps
282: where application_id=p_application_id
283: and p_effective_date between start_date and
284: nvl(end_date - ame_util.oneSecond,p_effective_date);

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

280: select ame_utility_pkg.is_seed_user(created_by)
281: from ame_calling_apps
282: where application_id=p_application_id
283: and p_effective_date between start_date and
284: nvl(end_date - ame_util.oneSecond,p_effective_date);
285: l_proc varchar2(72) := g_package || 'CHK_DELETE';
286: l_key number;
287: --
288: Begin