DBA Data[Home] [Help]

APPS.AME_ATR_SHD dependencies on AME_UTIL

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

60: from ame_attributes
61: where attribute_id = p_attribute_id
62: and p_effective_date
63: between start_date
64: and nvl(end_date - ame_util.oneSecond,p_effective_date);
65: --
66: l_fct_ret boolean;
67: --
68: Begin

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

146: set t.end_date = p_new_end_date
147: , t.object_version_number = l_object_version_number
148: where t.attribute_id = p_attribute_id
149: and p_effective_date
150: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
151: ;
152: --
153: --
154: p_object_version_number := l_object_version_number;

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

192: ,created_by
193: from ame_attributes
194: where attribute_id = p_attribute_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: --