APPS.AME_ATTRIBUTE_API dependencies on AME_CONDITIONS

Line 635: from ame_conditions

631: l_con_end_date date;
632:
633: cursor c_sel1 is
634: select condition_id, object_version_number
635: from ame_conditions
636: where attribute_id = p_attribute_id
637: and sysdate between start_date and
638: nvl(end_date - ame_util.oneSecond,sysdate);
639:

Line 821: ame_conditions,

817: for tempRule in ruleCursor(applicationIdIn => applicationIdIn) loop
818: select count(*)
819: into tempCount
820: from
821: ame_conditions,
822: ame_condition_usages
823: where
824: ame_conditions.attribute_id = attributeIdIn and
825: ame_conditions.condition_id = ame_condition_usages.condition_id and

Line 824: ame_conditions.attribute_id = attributeIdIn and

820: from
821: ame_conditions,
822: ame_condition_usages
823: where
824: ame_conditions.attribute_id = attributeIdIn and
825: ame_conditions.condition_id = ame_condition_usages.condition_id and
826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

Line 825: ame_conditions.condition_id = ame_condition_usages.condition_id and

821: ame_conditions,
822: ame_condition_usages
823: where
824: ame_conditions.attribute_id = attributeIdIn and
825: ame_conditions.condition_id = ame_condition_usages.condition_id and
826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and

Line 827: sysdate between ame_conditions.start_date and

823: where
824: ame_conditions.attribute_id = attributeIdIn and
825: ame_conditions.condition_id = ame_condition_usages.condition_id and
826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and

Line 828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and

824: ame_conditions.attribute_id = attributeIdIn and
825: ame_conditions.condition_id = ame_condition_usages.condition_id and
826: ame_condition_usages.rule_id = tempRule.rule_id and
827: sysdate between ame_conditions.start_date and
828: nvl(ame_conditions.end_date - ame_util.oneSecond, sysdate) and
829: ((sysdate between ame_condition_usages.start_date and
830: nvl(ame_condition_usages.end_date - ame_util.oneSecond, sysdate)) or
831: (sysdate < ame_condition_usages.start_date and
832: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,