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_ACTION_PKG dependencies on AME_RULES

Line 797: from ame_rules,

793: of rules to capture future rule start dates.
794: */
795: select count(*)
796: into useCount
797: from ame_rules,
798: ame_action_usages
799: where
800: ame_rules.rule_id = ame_action_usages.rule_id and
801: ame_action_usages.action_id = actionIdIn and

Line 800: ame_rules.rule_id = ame_action_usages.rule_id and

796: into useCount
797: from ame_rules,
798: ame_action_usages
799: where
800: ame_rules.rule_id = ame_action_usages.rule_id and
801: ame_action_usages.action_id = actionIdIn and
802: ((sysdate between ame_rules.start_date and
803: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
804: (sysdate < ame_rules.start_date and

Line 802: ((sysdate between ame_rules.start_date and

798: ame_action_usages
799: where
800: ame_rules.rule_id = ame_action_usages.rule_id and
801: ame_action_usages.action_id = actionIdIn and
802: ((sysdate between ame_rules.start_date and
803: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
804: (sysdate < ame_rules.start_date and
805: ame_rules.start_date < nvl(ame_rules.end_date,ame_rules.start_date + ame_util.oneSecond))) and
806: ((sysdate between ame_action_usages.start_date and

Line 803: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or

799: where
800: ame_rules.rule_id = ame_action_usages.rule_id and
801: ame_action_usages.action_id = actionIdIn and
802: ((sysdate between ame_rules.start_date and
803: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
804: (sysdate < ame_rules.start_date and
805: ame_rules.start_date < nvl(ame_rules.end_date,ame_rules.start_date + ame_util.oneSecond))) and
806: ((sysdate between ame_action_usages.start_date and
807: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

Line 804: (sysdate < ame_rules.start_date and

800: ame_rules.rule_id = ame_action_usages.rule_id and
801: ame_action_usages.action_id = actionIdIn and
802: ((sysdate between ame_rules.start_date and
803: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
804: (sysdate < ame_rules.start_date and
805: ame_rules.start_date < nvl(ame_rules.end_date,ame_rules.start_date + ame_util.oneSecond))) and
806: ((sysdate between ame_action_usages.start_date and
807: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
808: (sysdate < ame_action_usages.start_date and

Line 805: ame_rules.start_date < nvl(ame_rules.end_date,ame_rules.start_date + ame_util.oneSecond))) and

801: ame_action_usages.action_id = actionIdIn and
802: ((sysdate between ame_rules.start_date and
803: nvl(ame_rules.end_date - ame_util.oneSecond, sysdate)) or
804: (sysdate < ame_rules.start_date and
805: ame_rules.start_date < nvl(ame_rules.end_date,ame_rules.start_date + ame_util.oneSecond))) and
806: ((sysdate between ame_action_usages.start_date and
807: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
808: (sysdate < ame_action_usages.start_date and
809: ame_action_usages.start_date < nvl(ame_action_usages.end_date,ame_action_usages.start_date + ame_util.oneSecond)));