APPS.AME_MAN_BUS dependencies on AME_ATTRIBUTES

Line 137: -- Validates that the attribute_id is a foreign key to ame_attributes.attribute_id.

133: --
134: -- {Start Of Comments}
135: --
136: -- Description:
137: -- Validates that the attribute_id is a foreign key to ame_attributes.attribute_id.
138: --
139: -- Prerequisites:
140: -- None.
141: --

Line 167: from ame_attributes

163: l_proc varchar2(72) := g_package||'chk_attribute_id';
164: tempCount integer;
165: cursor c_sel1 is
166: select null
167: from ame_attributes
168: where
169: attribute_id = p_attribute_id and
170: p_effective_date between start_date and
171: nvl(end_date - ame_util.oneSecond, p_effective_date) ;