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