APPS.AME_ACF_SHD dependencies on AME_UTIL

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

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

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

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

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

197: from ame_action_type_config
198: where action_type_id = p_action_type_id
199: and application_id = p_application_id
200: and p_effective_date
201: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)
202: for update nowait;
203: --
204: --
205: --