DBA Data[Home] [Help]

APPS.AME_CNU_BUS dependencies on AME_RULES

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

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

Line 110: from ame_rules

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