APPS.AME_ACF_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 501: ,ame_action_types aty

497: select null
498: from ame_rule_usages aru
499: ,ame_action_usages aau
500: ,ame_actions act
501: ,ame_action_types aty
502: where aru.item_id = p_application_id
503: and aau.rule_id = aru.rule_id
504: and aau.action_id = act.action_id
505: and act.action_type_id = aty.action_type_id