APPS.AME_APU_SHD dependencies on AME_UTIL

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

54: from ame_approver_type_usages
55: where approver_type_id = p_approver_type_id
56: and action_type_id = p_action_type_id
57: and p_effective_date
58: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);
59: --
60: l_fct_ret boolean;
61: --
62: Begin

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

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

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

191: from ame_approver_type_usages
192: where approver_type_id = p_approver_type_id
193: and action_type_id = p_action_type_id
194: and p_effective_date
195: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)
196: for update nowait;
197: --
198: --
199: --