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_TCA_SHD dependencies on PQH_TRANSACTION_CATEGORIES

Line 327: from pqh_transaction_categories

323: where table_alias = p_table_alias;
324: --
325: cursor csr_txn_cat_id (p_tran_cat_short_name IN VARCHAR2) is
326: select transaction_category_id
327: from pqh_transaction_categories
328: where short_name = p_tran_cat_short_name
329: and business_group_id is null;
330: --
331: cursor csr_txn_cat_att_id ( p_attribute_id IN NUMBER, p_txn_category_id IN NUMBER ) is

Line 345: from pqh_transaction_categories

341: --
342: --
343: Cursor csr_local_txn_cat_id is
344: select transaction_category_id
345: from pqh_transaction_categories
346: where short_name = p_tran_cat_short_name
347: and business_group_id is not null;
348: --
349: --

Line 458: from pqh_transaction_categories

454: WHERE attribute_id = l_attribute_id
455: -- AND NVL(last_updated_by,-1) in (1,-1);
456: AND transaction_category_id in (
457: select transaction_category_id
458: from pqh_transaction_categories
459: where short_name = p_tran_cat_short_name
460: and business_group_id is not null);
461: End if; -- Propogate changes to bg specific txn category attributes
462: