APPS.AME_MIGRATION_PKG dependencies on DUAL

Line 12: from dual;

8: pragma autonomous_transaction;
9: begin
10: select ame_exceptions_log_s.nextval
11: into l_log_id
12: from dual;
13:
14: insert into ame_exceptions_log
15: (log_id,package_name,routine_name,transaction_id,application_id,exception_number,exception_string)
16: values

Line 385: set itu.item_id_query = 'select :transactionId from dual'

381: --+
382: --+Correct all item_id_queries
383: --+
384: update ame_item_class_usages itu
385: set itu.item_id_query = 'select :transactionId from dual'
386: where itu.item_id_query = 'select :transaction_id from dual'
387: and sysdate between itu.start_date
388: and nvl(itu.end_date - (1/86400), sysdate)
389: and exists (select null

Line 386: where itu.item_id_query = 'select :transaction_id from dual'

382: --+Correct all item_id_queries
383: --+
384: update ame_item_class_usages itu
385: set itu.item_id_query = 'select :transactionId from dual'
386: where itu.item_id_query = 'select :transaction_id from dual'
387: and sysdate between itu.start_date
388: and nvl(itu.end_date - (1/86400), sysdate)
389: and exists (select null
390: from ame_item_classes itc