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_RLU_SHD dependencies on AME_UTIL

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

59: from ame_rule_usages
60: where rule_id = p_rule_id
61: and item_id = p_item_id
62: and ( p_effective_date
63: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
64: or
65: (p_effective_date < start_date and
66: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
67: --

Line 66: start_date < nvl(end_date,start_date + ame_util.oneSecond)));

62: and ( p_effective_date
63: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
64: or
65: (p_effective_date < start_date and
66: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
67: --
68: l_fct_ret boolean;
69: --
70: Begin

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

163: where t.rule_id = p_rule_id
164: and t.item_id = p_item_id
165: and t.start_date = p_old_start_date
166: and ( p_effective_date
167: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
168: or
169: (p_effective_date < t.start_date and
170: t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));
171: --

Line 170: t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));

166: and ( p_effective_date
167: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
168: or
169: (p_effective_date < t.start_date and
170: t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));
171: --
172: --
173: p_object_version_number := l_object_version_number;
174: hr_utility.set_location(' Leaving:'||l_proc, 15);

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

214: where rule_id = p_rule_id
215: and item_id = p_item_id
216: and start_date = p_old_start_date
217: and ( p_effective_date
218: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
219: or
220: (p_effective_date < start_date and
221: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
222: for update nowait;

Line 221: start_date < nvl(end_date,start_date + ame_util.oneSecond)))

217: and ( p_effective_date
218: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
219: or
220: (p_effective_date < start_date and
221: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
222: for update nowait;
223: --
224: --
225: --

Line 307: nvl(end_date - ame_util.oneSecond, p_effective_date)) or

303: into l_dummy
304: from ame_rules
305: where rule_id = p_rule_id and
306: ((p_effective_date between start_date and
307: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
308: (p_effective_date < start_date and
309: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
310: for update of end_date nowait;
311: exception

Line 309: start_date < nvl(end_date,start_date + ame_util.oneSecond)))

305: where rule_id = p_rule_id and
306: ((p_effective_date between start_date and
307: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
308: (p_effective_date < start_date and
309: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
310: for update of end_date nowait;
311: exception
312: when others then
313: --