APPS.AME_AXU_BUS dependencies on AME_ACTION_TYPES

Line 17: -- Validates that the action_type_id is a foreign key to ame_action_types.action_type_id.

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

Line 47: from ame_action_types

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

Line 288: from ame_action_types

284: (p_action_type_id in number) is
285: l_proc varchar2(72) := g_package||'chk_delete';
286: cursor c_sel1 Is
287: select null
288: from ame_action_types
289: where
290: action_type_id = p_action_type_id and
291: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
292: ame_utility_pkg.check_seeddb = 'N';