APPS.AME_APT_BUS dependencies on AME_APPROVER_TYPES

Line 127: (p_associated_column1 => 'ame_approver_types.orig_system') then

123: close chk_exist_orig_system ;
124: exception
125: when app_exception.application_exception then
126: if hr_multi_message.exception_add
127: (p_associated_column1 => 'ame_approver_types.orig_system') then
128: raise;
129: end if;
130: hr_utility.set_location(' Leaving:'|| l_proc, 60);
131: end chk_orig_system ;

Line 167: from ame_approver_types

163: ) IS
164: --
165: cursor csr_name is
166: select null
167: from ame_approver_types
168: where orig_system = p_orig_system
169: and p_effective_date between start_date and
170: nvl(end_date - ame_util.oneSecond, p_effective_date);
171: --

Line 191: (p_associated_column1 => 'ame_approver_types.UNIQUE'

187: hr_utility.set_location(' Leaving:'||l_proc,30);
188: exception
189: when app_exception.application_exception then
190: if hr_multi_message.exception_add
191: (p_associated_column1 => 'ame_approver_types.UNIQUE'
192: ) then
193: hr_utility.set_location(' Leaving:'||l_proc, 40);
194: raise;
195: end if;

Line 242: from ame_approver_types

238: --
239:
240: cursor csr_isSeeded is
241: select null
242: from ame_approver_types
243: where approver_type_id = p_approver_type_id
244: and p_effective_date between start_date
245: and nvl(end_date - ame_util.oneSecond, p_effective_date)
246: and ame_utility_pkg.is_seed_user(created_by) = ame_util.seededDataCreatedById;

Line 642: from ame_approver_types

638: l_orig_system varchar2(100);
639: --
640: cursor csr_origSystem is
641: select orig_system
642: from ame_approver_types
643: where approver_type_id = p_rec.approver_type_id
644: and p_effective_date between start_date
645: and nvl(end_date - ame_util.oneSecond, p_effective_date);
646: Begin