APPS.AME_ACU_BUS dependencies on AME_ACTIONS

Line 17: -- Validates that the action_id is a foreign key to ame_actions.action_id.

13: --
14: -- {Start Of Comments}
15: --
16: -- Description:
17: -- Validates that the action_id is a foreign key to ame_actions.action_id.
18: --
19: -- Prerequisites:
20: -- None.
21: --

Line 47: from ame_actions

43: l_proc varchar2(72) := g_package||'chk_action_id';
44: tempCount integer;
45: cursor c_sel1 is
46: select null
47: from ame_actions
48: where
49: action_id = p_action_id and
50: p_effective_date between start_date and
51: nvl(end_date - ame_util.oneSecond, p_effective_date) ;