DBA Data[Home] [Help]

APPS.AME_ACU_BUS dependencies on AME_RULES

Line 78: -- Validates that the rule_id is a foreign key to ame_rules.rule_id.

74: --
75: -- {Start Of Comments}
76: --
77: -- Description:
78: -- Validates that the rule_id is a foreign key to ame_rules.rule_id.
79: --
80: -- Prerequisites:
81: -- None.
82: --

Line 108: from ame_rules

104: l_proc varchar2(72) := g_package||'chk_rule_id';
105: tempCount integer;
106: cursor c_sel1 is
107: select null
108: from ame_rules
109: where
110: rule_id = p_rule_id and
111: ((p_effective_date between start_date and
112: nvl(end_date - ame_util.oneSecond, p_effective_date)) or