APPS.AME_CFV_SHD dependencies on AME_UTIL

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

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

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

154: , t.object_version_number = l_object_version_number
155: where t.application_id = p_application_id
156: and t.variable_name = p_variable_name
157: and p_effective_date
158: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
159: ;
160: --
161: --
162: p_object_version_number := l_object_version_number;

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

198: from ame_config_vars
199: where application_id = p_application_id
200: and variable_name = p_variable_name
201: and p_effective_date
202: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
203: for update nowait;
204: --
205: --
206: --