APPS.AME_ITU_BUS dependencies on AME_ITEM_CLASSES

Line 83: -- ame_item_classes table and must be valid over the given date ranges

79: -- {Start Of Comments}
80: --
81: -- Description:
82: -- This procedure ensure that item_class_id must be already defined in
83: -- ame_item_classes table and must be valid over the given date ranges
84: --
85: -- Pre-Requisites:
86: -- None
87: --

Line 97: -- ame_item_classes table

93: -- Processing continues if a valid item_class_id has been entered.
94: --
95: -- Post Failure:
96: -- An application error is raised if the item_class_id is not defined in
97: -- ame_item_classes table
98: --
99: -- Access Status:
100: -- Internal Row Handler Use Only.
101: --

Line 110: from ame_item_classes

106: ) IS
107: --
108: cursor csr_item_class_id is
109: select null
110: from ame_item_classes
111: where item_class_id = p_item_class_id
112: and p_effective_date between start_date
113: and nvl(end_date - ame_util.oneSecond, p_effective_date);
114: l_proc varchar2(72) := g_package || 'CHK_ITEM_CLASS_ID';