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: INSERT INTO pqh_txn_category_attributes
470: (txn_category_attribute_id,
471: attribute_id,

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

511: For lcl_tca_rec in csr_local_txn_cat_id loop
512: --
513: l_transaction_category_id := lcl_tca_rec.transaction_category_id;
514:
515: select pqh_txn_category_attributes_s.nextval into l_txn_category_attribute_id from dual;
516:
517: INSERT INTO pqh_txn_category_attributes
518: (txn_category_attribute_id,
519: attribute_id,