DBA Data[Home] [Help]

APPS.AME_CNU_INS dependencies on AME_CONDITIONS

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 528: from ame_conditions

524: --
525: begin
526: select null
527: into l_dummy
528: from ame_conditions
529: where condition_id = p_rec.condition_id
530: and p_effective_date between start_date and
531: nvl(end_date - ame_util.oneSecond, p_effective_date)
532: for update of end_date nowait;