APPS.PQH_TCA_SHD dependencies on DUAL

Line 306: cursor c1 is select userenv('LANG') from dual ;

302: l_creation_date pqh_attributes.creation_date%TYPE;
303: l_last_update_date pqh_attributes.last_update_date%TYPE;
304: l_last_update_login pqh_attributes.last_update_login%TYPE;
305: --
306: cursor c1 is select userenv('LANG') from dual ;
307: --
308: --
309: -- developer key is short_name
310: --

Line 467: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;

463: else
464:
465: -- insert into pqh_txn_category_attributes table
466:
467: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;
468:
469: --
470: -- Added the following code as a part of Zero Downtime Patching Project.
471: -- Code Starts Here.

Line 536: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;

532: For lcl_tca_rec in csr_local_txn_cat_id loop
533: --
534: l_transaction_category_id := lcl_tca_rec.transaction_category_id;
535:
536: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;
537:
538: --
539: -- Added the following code as a part of Zero Downtime Patching Project.
540: -- Code Starts Here.