eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TEM_SHD dependencies on DUAL

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

340: l_last_update_date pqh_templates.last_update_date%TYPE;
341: l_last_update_login pqh_templates.last_update_login%TYPE;
342: --
343: --
344: cursor c1 is select userenv('LANG') from dual ;
345: --
346: Cursor c2 is select transaction_category_id
347: from pqh_transaction_categories
348: where short_name = p_tran_cat_short_name

Line 356: Cursor C_Sel1 is select pqh_templates_s.nextval from sys.dual;

352: from pqh_templates
353: where short_name = p_short_name ;
354: --
355: --
356: Cursor C_Sel1 is select pqh_templates_s.nextval from sys.dual;
357: --
358: --
359: BEGIN
360: --