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_ATTRIBUTE_PKG dependencies on AME_ACTION_TYPES

Line 164: ame_action_types.name

160: end calculateUseCount;
161: function getApprovalTypeNames(attributeIdIn in integer) return varchar2 as
162: cursor getApprovalTypeNames(attributeIdIn in integer) is
163: select
164: ame_action_types.name
165: from
166: ame_action_types,
167: ame_mandatory_attributes
168: where

Line 166: ame_action_types,

162: cursor getApprovalTypeNames(attributeIdIn in integer) is
163: select
164: ame_action_types.name
165: from
166: ame_action_types,
167: ame_mandatory_attributes
168: where
169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and
170: ame_mandatory_attributes.attribute_id = attributeIdIn and

Line 169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and

165: from
166: ame_action_types,
167: ame_mandatory_attributes
168: where
169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and
170: ame_mandatory_attributes.attribute_id = attributeIdIn and
171: sysdate between ame_action_types.start_date and
172: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
173: sysdate between ame_mandatory_attributes.start_date and

Line 171: sysdate between ame_action_types.start_date and

167: ame_mandatory_attributes
168: where
169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and
170: ame_mandatory_attributes.attribute_id = attributeIdIn and
171: sysdate between ame_action_types.start_date and
172: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
173: sysdate between ame_mandatory_attributes.start_date and
174: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
175: order by name;

Line 172: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and

168: where
169: ame_action_types.action_type_id = ame_mandatory_attributes.action_type_id and
170: ame_mandatory_attributes.attribute_id = attributeIdIn and
171: sysdate between ame_action_types.start_date and
172: nvl(ame_action_types.end_date - ame_util.oneSecond, sysdate) and
173: sysdate between ame_mandatory_attributes.start_date and
174: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate)
175: order by name;
176: tempCount integer;