Line 287: -- We need to trap the 2 parent objects viz. ame_rules and ame_conditions
283: end if;
284: --
285: hr_utility.set_location(' Leaving:'||l_proc, 30);
286: -- 287: -- We need to trap the 2 parent objects viz. ame_rules and ame_conditions 288: --
289: begin
290: select null
291: into l_dummy
Line 292: from ame_conditions
288: --
289: begin
290: select null
291: into l_dummy 292: from ame_conditions 293: where condition_id = p_condition_id
294: and p_effective_date between start_date and
295: nvl(end_date - ame_util.oneSecond, p_effective_date)
296: for update of end_date nowait;