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_CONDITION_API dependencies on AME_RULE_USAGES

Line 468: ame_rule_usages,

464: nvl(end_date - ame_util.oneSecond,sysdate);
465: cursor csr_rules(p_chk_condition_id number) is
466: select null
467: from ame_rules,
468: ame_rule_usages,
469: ame_condition_usages
470: where ame_rules.rule_id = ame_condition_usages.rule_id
471: and ame_rules.rule_id = ame_rule_usages.rule_id
472: and ame_condition_usages.condition_id = p_chk_condition_id

Line 471: and ame_rules.rule_id = ame_rule_usages.rule_id

467: from ame_rules,
468: ame_rule_usages,
469: ame_condition_usages
470: where ame_rules.rule_id = ame_condition_usages.rule_id
471: and ame_rules.rule_id = ame_rule_usages.rule_id
472: and ame_condition_usages.condition_id = p_chk_condition_id
473: and ((sysdate between ame_rules.start_date and
474: nvl(ame_rules.end_date - ame_util.oneSecond,sysdate))
475: or

Line 479: and ((sysdate between ame_rule_usages.start_date and

475: or
476: (sysdate < ame_rules.start_date and
477: ame_rules.start_date < nvl(ame_rules.end_date,
478: ame_rules.start_date + ame_util.oneSecond)))
479: and ((sysdate between ame_rule_usages.start_date and
480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))
481: or
482: (sysdate < ame_rule_usages.start_date and
483: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

Line 480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))

476: (sysdate < ame_rules.start_date and
477: ame_rules.start_date < nvl(ame_rules.end_date,
478: ame_rules.start_date + ame_util.oneSecond)))
479: and ((sysdate between ame_rule_usages.start_date and
480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))
481: or
482: (sysdate < ame_rule_usages.start_date and
483: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
484: ame_rule_usages.start_date + ame_util.oneSecond)))

Line 482: (sysdate < ame_rule_usages.start_date and

478: ame_rules.start_date + ame_util.oneSecond)))
479: and ((sysdate between ame_rule_usages.start_date and
480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))
481: or
482: (sysdate < ame_rule_usages.start_date and
483: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
484: ame_rule_usages.start_date + ame_util.oneSecond)))
485: and ((sysdate between ame_condition_usages.start_date and
486: nvl(ame_condition_usages.end_date-ame_util.oneSecond,sysdate))

Line 483: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,

479: and ((sysdate between ame_rule_usages.start_date and
480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))
481: or
482: (sysdate < ame_rule_usages.start_date and
483: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
484: ame_rule_usages.start_date + ame_util.oneSecond)))
485: and ((sysdate between ame_condition_usages.start_date and
486: nvl(ame_condition_usages.end_date-ame_util.oneSecond,sysdate))
487: or

Line 484: ame_rule_usages.start_date + ame_util.oneSecond)))

480: nvl(ame_rule_usages.end_date - ame_util.oneSecond,sysdate))
481: or
482: (sysdate < ame_rule_usages.start_date and
483: ame_rule_usages.start_date < nvl(ame_rule_usages.end_date,
484: ame_rule_usages.start_date + ame_util.oneSecond)))
485: and ((sysdate between ame_condition_usages.start_date and
486: nvl(ame_condition_usages.end_date-ame_util.oneSecond,sysdate))
487: or
488: (sysdate < ame_condition_usages.start_date and