APPS.AME_CNU_INS dependencies on AME_RULES

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

519: -- MURTHY_CHANGES
520: p_validation_start_date := sysdate;
521: p_validation_end_date := ame_utility_pkg.endOfTime;
522: --
523: -- Lock the parent rows in ame_rules and ame_conditions
524: --
525: begin
526: select null
527: into l_dummy

Line 535: from ame_rules

531: nvl(end_date - ame_util.oneSecond, p_effective_date)
532: for update of end_date nowait;
533: select null
534: into l_dummy
535: from ame_rules
536: where rule_id = p_rec.rule_id and
537: ((p_effective_date between start_date and
538: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
539: (p_effective_date < start_date and