APPS.AME_CNU_BUS dependencies on AME_CONDITIONS

Line 17: -- Validates that the condition_id is a foreign key to ame_conditions.condition_id.

13: --
14: -- {Start Of Comments}
15: --
16: -- Description:
17: -- Validates that the condition_id is a foreign key to ame_conditions.condition_id.
18: -- Check that an attribute usage exists for the attribute this condition is based on
19: -- within the specified transaction type.
20: --
21: -- Prerequisites:

Line 49: from ame_conditions

45: l_proc varchar2(72) := g_package||'chk_condition_id';
46: tempCount integer;
47: cursor c_sel1 is
48: select null
49: from ame_conditions
50: where
51: condition_id = p_condition_id and
52: p_effective_date between start_date and
53: nvl(end_date - ame_util.oneSecond, p_effective_date) ;