APPS.AME_MAN_SHD dependencies on AME_UTIL

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

55: from ame_mandatory_attributes
56: where attribute_id = p_attribute_id
57: and action_type_id = p_action_type_id
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.attribute_id = p_attribute_id
154: and t.action_type_id = p_action_type_id
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_mandatory_attributes
194: where attribute_id = p_attribute_id
195: and action_type_id = p_action_type_id
196: and p_effective_date
197: between start_date and nvl(end_date - ame_util.oneSecond, sysdate)
198: for update nowait;
199: --
200: --
201: --