APPS.AME_GPI_SHD dependencies on AME_UTIL

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

57: from ame_approval_group_items
58: where approval_group_item_id = p_approval_group_item_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 147: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)

143: set t.end_date = p_new_end_date
144: , t.object_version_number = l_object_version_number
145: where t.approval_group_item_id = p_approval_group_item_id
146: and p_effective_date
147: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
148: ;
149: --
150: --
151: p_object_version_number := l_object_version_number;

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

186: ,object_version_number
187: from ame_approval_group_items
188: where approval_group_item_id = p_approval_group_item_id
189: and p_effective_date
190: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
191: for update nowait;
192: --
193: --
194: --