DBA Data[Home] [Help]

APPS.AME_RLU_BUS dependencies on AME_RULES

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

175: --
176: -- {Start Of Comments}
177: --
178: -- Description:
179: -- Validates that the rule_id is a foreign key to ame_rules.rule_id.
180: --
181: -- Prerequisites:
182: -- None.
183: --

Line 209: from ame_rules

205: l_proc varchar2(72) := g_package||'chk_rule_id';
206: tempCount integer;
207: cursor c_sel1 is
208: select null
209: from ame_rules
210: where
211: rule_id = p_rule_id and
212: ((p_effective_date between start_date and
213: nvl(end_date - ame_util.oneSecond, p_effective_date)) or