APPS.AME_ACU_INS dependencies on AME_RULES

Line 517: -- Lock the parent rows in ame_rules and ame_conditions

513: -- MURTHY_CHANGES
514: p_validation_start_date := sysdate;
515: p_validation_end_date := ame_utility_pkg.endOfTime;
516: --
517: -- Lock the parent rows in ame_rules and ame_conditions
518: --
519: begin
520: select null
521: into l_dummy

Line 529: from ame_rules

525: nvl(end_date - ame_util.oneSecond, p_effective_date)
526: for update of end_date nowait;
527: select null
528: into l_dummy
529: from ame_rules
530: where rule_id = p_rec.rule_id and
531: ((p_effective_date between start_date and
532: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
533: (p_effective_date < start_date and