APPS.AME_MAN_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 242: from ame_action_types

238: l_proc varchar2(72) := g_package||'chk_seeded_action_type';
239:
240: cursor c_sell is
241: select created_by
242: from ame_action_types
243: where action_type_id = p_action_type_id and
244: p_effective_date between start_date and
245: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
246: l_created_by number;

Line 302: from ame_action_types

298: (p_action_type_id in number) is
299: l_proc varchar2(72) := g_package||'chk_delete';
300: cursor c_sel1 Is
301: select null
302: from ame_action_types
303: where
304: action_type_id = p_action_type_id and
305: ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById and
306: ame_utility_pkg.check_seeddb = 'N';