APPS.AME_ACTION_PKG dependencies on AME_ACTION_USAGES

Line 798: ame_action_usages

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
802: ((sysdate between ame_rules.start_date 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 801: ame_action_usages.action_id = actionIdIn and

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
805: ame_rules.start_date < nvl(ame_rules.end_date,ame_rules.start_date + ame_util.oneSecond))) and

Line 806: ((sysdate between ame_action_usages.start_date 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)));
810: if(useCount > 0) then

Line 807: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or

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)));
810: if(useCount > 0) then
811: return(true);

Line 808: (sysdate < ame_action_usages.start_date and

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)));
810: if(useCount > 0) then
811: return(true);
812: end if;

Line 809: ame_action_usages.start_date < nvl(ame_action_usages.end_date,ame_action_usages.start_date + ame_util.oneSecond)));

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)));
810: if(useCount > 0) then
811: return(true);
812: end if;
813: return(false);