DBA Data[Home] [Help]

APPS.AME_RLU_INS dependencies on AME_RULES

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

528: -- MURTHY_CHANGES
529: p_validation_start_date := sysdate;
530: p_validation_end_date := ame_utility_pkg.endOfTime;
531: --
532: -- Lock the parent rows in ame_rules and ame_conditions
533: --
534: begin
535: select null
536: into l_dummy

Line 537: from ame_rules

533: --
534: begin
535: select null
536: into l_dummy
537: from ame_rules
538: where rule_id = p_rec.rule_id and
539: ((p_effective_date between start_date and
540: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
541: (p_effective_date < start_date and