DBA Data[Home] [Help]

APPS.AME_ACU_SHD dependencies on AME_ACTIONS

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;