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_API dependencies on AME_MANDATORY_ATTRIBUTES

Line 642: from ame_mandatory_attributes

638: nvl(end_date - ame_util.oneSecond,sysdate);
639:
640: cursor c_sel2 is
641: select null
642: from ame_mandatory_attributes
643: where attribute_id = p_attribute_id and
644: sysdate between start_date and
645: nvl(end_date - ame_util.oneSecond, sysdate) ;
646:

Line 840: ame_mandatory_attributes,

836: else
837: select count(*)
838: into tempCount
839: from
840: ame_mandatory_attributes,
841: ame_actions,
842: ame_action_usages
843: where
844: ame_mandatory_attributes.attribute_id = attributeIdIn and

Line 844: ame_mandatory_attributes.attribute_id = attributeIdIn and

840: ame_mandatory_attributes,
841: ame_actions,
842: ame_action_usages
843: where
844: ame_mandatory_attributes.attribute_id = attributeIdIn and
845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and

Line 845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and

841: ame_actions,
842: ame_action_usages
843: where
844: ame_mandatory_attributes.attribute_id = attributeIdIn and
845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and

Line 848: sysdate between ame_mandatory_attributes.start_date and

844: ame_mandatory_attributes.attribute_id = attributeIdIn and
845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and

Line 849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and

845: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
846: ame_actions.action_id = ame_action_usages.action_id and
847: ame_action_usages.rule_id = tempRule.rule_id and
848: sysdate between ame_mandatory_attributes.start_date and
849: nvl(ame_mandatory_attributes.end_date - ame_util.oneSecond, sysdate) and
850: sysdate between ame_actions.start_date and
851: nvl(ame_actions.end_date - ame_util.oneSecond, sysdate) and
852: ((sysdate between ame_action_usages.start_date and
853: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or