APPS.AME_CONDITION_API dependencies on AME_RULES

Line 467: from ame_rules,

463: and sysdate between start_date and
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

Line 470: where ame_rules.rule_id = ame_condition_usages.rule_id

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
473: and ((sysdate between ame_rules.start_date and
474: nvl(ame_rules.end_date - ame_util.oneSecond,sysdate))

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 473: and ((sysdate between ame_rules.start_date and

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
476: (sysdate < ame_rules.start_date and
477: ame_rules.start_date < nvl(ame_rules.end_date,

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

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
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)))

Line 476: (sysdate < ame_rules.start_date and

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
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))

Line 477: ame_rules.start_date < nvl(ame_rules.end_date,

473: and ((sysdate between ame_rules.start_date and
474: nvl(ame_rules.end_date - ame_util.oneSecond,sysdate))
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

Line 478: ame_rules.start_date + ame_util.oneSecond)))

474: nvl(ame_rules.end_date - ame_util.oneSecond,sysdate))
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