APPS.AME_AXU_SHD dependencies on AME_UTIL

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

55: from ame_action_type_usages
56: where action_type_id = p_action_type_id
57: and rule_type = p_rule_type
58: and p_effective_date
59: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);
60: --
61: l_fct_ret boolean;
62: --
63: Begin

Line 156: and nvl(t.end_date - ame_util.oneSecond,sysdate);

152: ,t.object_version_number = l_object_version_number
153: where t.action_type_id = p_action_type_id
154: and t.rule_type = p_rule_type
155: and p_effective_date between t.start_date
156: and nvl(t.end_date - ame_util.oneSecond,sysdate);
157: --
158: --
159: p_object_version_number := l_object_version_number;
160: hr_utility.set_location(' Leaving:'||l_proc, 15);

Line 197: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)

193: from ame_action_type_usages
194: where action_type_id = p_action_type_id
195: and rule_type = p_rule_type
196: and p_effective_date
197: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)
198: for update nowait;
199: --
200: --
201: --