APPS.AME_CNU_SHD dependencies on AME_UTIL

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

55: from ame_condition_usages
56: where condition_id = p_condition_id
57: and rule_id = p_rule_id
58: and ( p_effective_date
59: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
60: or
61: (p_effective_date < start_date and
62: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
63: --

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

58: and ( p_effective_date
59: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
60: or
61: (p_effective_date < start_date and
62: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
63: --
64: l_fct_ret boolean;
65: --
66: Begin

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

156: , t.object_version_number = l_object_version_number
157: where t.condition_id = p_condition_id
158: and t.rule_id = p_rule_id
159: and ( p_effective_date
160: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
161: or
162: (p_effective_date < t.start_date and
163: t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));
164: --

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

159: and ( p_effective_date
160: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
161: or
162: (p_effective_date < t.start_date and
163: t.start_date < nvl(t.end_date,t.start_date + ame_util.oneSecond)));
164: --
165: --
166: p_object_version_number := l_object_version_number;
167: hr_utility.set_location(' Leaving:'||l_proc, 15);

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

201: from ame_condition_usages
202: where condition_id = p_condition_id
203: and rule_id = p_rule_id
204: and ( p_effective_date
205: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
206: or
207: (p_effective_date < start_date and
208: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
209: for update nowait;

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

204: and ( p_effective_date
205: between start_date and nvl(end_date - ame_util.oneSecond,p_effective_date)
206: or
207: (p_effective_date < start_date and
208: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
209: for update nowait;
210: --
211: --
212: --

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

291: into l_dummy
292: from ame_conditions
293: where condition_id = p_condition_id
294: and p_effective_date between start_date and
295: nvl(end_date - ame_util.oneSecond, p_effective_date)
296: for update of end_date nowait;
297: /* select null
298: into l_dummy
299: from ame_rules

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

298: into l_dummy
299: from ame_rules
300: where rule_id = p_rule_id and
301: ((p_effective_date between start_date and
302: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
303: (p_effective_date < start_date and
304: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
305: for update of end_date nowait;*/
306: exception

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

300: where rule_id = p_rule_id and
301: ((p_effective_date between start_date and
302: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
303: (p_effective_date < start_date and
304: start_date < nvl(end_date,start_date + ame_util.oneSecond)))
305: for update of end_date nowait;*/
306: exception
307: when others then
308: --