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

Line 61: and nvl(end_date - ame_util.oneSecond,p_effective_date);

57: where approval_group_id = p_approval_group_id
58: and application_id = p_application_id
59: and p_effective_date
60: between start_date
61: and nvl(end_date - ame_util.oneSecond,p_effective_date);
62: --
63: l_fct_ret boolean;
64: --
65: Begin

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

147: , t.object_version_number = l_object_version_number
148: where t.approval_group_id = p_approval_group_id
149: and t.application_id = p_application_id
150: and p_effective_date
151: between t.start_date and nvl(t.end_date - ame_util.oneSecond,p_effective_date)
152: ;
153: --
154: --
155: p_object_version_number := l_object_version_number;

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

190: from ame_approval_group_config
191: where approval_group_id = p_approval_group_id
192: and application_id = p_application_id
193: and p_effective_date
194: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
195: for update nowait;
196: --
197: --
198: --