APPS.AME_APU_BUS dependencies on AME_ACTION_TYPES

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

69: --
70: -- {Start Of Comments}
71: --
72: -- Description:
73: -- Validates that the action_type_id is a foreign key to ame_action_types.action_type_id
74: --
75: -- Prerequisites:
76: -- None.
77: --

Line 103: from ame_action_types

99: l_proc varchar2(72) := g_package||'chk_action_type_id';
100: tempCount integer;
101: cursor c_sel1 is
102: select null
103: from ame_action_types
104: where
105: action_type_id = p_action_type_id and
106: p_effective_date between start_date and
107: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 247: from ame_action_types

243: (p_action_type_id in number) is
244: l_proc varchar2(72) := g_package||'chk_delete';
245: cursor c_sel1 Is
246: select null
247: from ame_action_types
248: where
249: ame_utility_pkg.check_seeddb = 'N' and
250: action_type_id = p_action_type_id and
251: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById;