APPS.AME_APU_BUS dependencies on AME_APPROVER_TYPES

Line 138: -- ame_approver_types.approver_type_id

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

Line 167: from ame_approver_types

163: p_action_type_id in number,
164: p_effective_date in date) is
165: cursor c_sel1 is
166: select null
167: from ame_approver_types
168: where
169: approver_type_id = p_approver_type_id and
170: p_effective_date between start_date and
171: nvl(end_date - ame_util.oneSecond, p_effective_date);