APPS.AME_CONDITION_API dependencies on AME_CONDITION_USAGES

Line 469: ame_condition_usages

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

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 472: and ame_condition_usages.condition_id = p_chk_condition_id

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

Line 485: and ((sysdate between ame_condition_usages.start_date and

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
489: ame_condition_usages.start_date <

Line 486: nvl(ame_condition_usages.end_date-ame_util.oneSecond,sysdate))

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
489: ame_condition_usages.start_date <
490: nvl(ame_condition_usages.end_date,

Line 488: (sysdate < ame_condition_usages.start_date and

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
489: ame_condition_usages.start_date <
490: nvl(ame_condition_usages.end_date,
491: ame_condition_usages.start_date + ame_util.oneSecond)));
492: --

Line 489: ame_condition_usages.start_date <

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
489: ame_condition_usages.start_date <
490: nvl(ame_condition_usages.end_date,
491: ame_condition_usages.start_date + ame_util.oneSecond)));
492: --
493: l_proc varchar2(72) := g_package||'delete_ame_condition';

Line 490: nvl(ame_condition_usages.end_date,

486: nvl(ame_condition_usages.end_date-ame_util.oneSecond,sysdate))
487: or
488: (sysdate < ame_condition_usages.start_date and
489: ame_condition_usages.start_date <
490: nvl(ame_condition_usages.end_date,
491: ame_condition_usages.start_date + ame_util.oneSecond)));
492: --
493: l_proc varchar2(72) := g_package||'delete_ame_condition';
494: l_object_version_number number;

Line 491: ame_condition_usages.start_date + ame_util.oneSecond)));

487: or
488: (sysdate < ame_condition_usages.start_date and
489: ame_condition_usages.start_date <
490: nvl(ame_condition_usages.end_date,
491: ame_condition_usages.start_date + ame_util.oneSecond)));
492: --
493: l_proc varchar2(72) := g_package||'delete_ame_condition';
494: l_object_version_number number;
495: l_start_date date;