eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_STV_SHD dependencies on AME_UTIL

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

56: where condition_id = p_condition_id
57: and string_value = p_string_value
58: and p_effective_date
59: between start_date
60: and nvl(end_date - ame_util.oneSecond,p_effective_date);
61: --
62: l_fct_ret boolean;
63: --
64: Begin

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

152: , t.object_version_number = l_object_version_number
153: where t.condition_id = p_condition_id
154: and t.string_value = p_string_value
155: and p_effective_date
156: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
157: ;
158: --
159: --
160: p_object_version_number := l_object_version_number;

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

195: from ame_string_values
196: where condition_id = p_condition_id
197: and string_value = p_string_value
198: and p_effective_date
199: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
200: for update nowait;
201: --
202: cursor csr_lck is
203: select null

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

203: select null
204: from AME_CONDITIONS
205: where condition_id = p_condition_id
206: and p_effective_date between start_date
207: and nvl(end_date - ame_util.oneSecond, p_effective_date)
208: for update of object_version_number nowait;
209: --
210: --
211: --