DBA Data[Home] [Help]

APPS.PQH_SAT_SHD dependencies on PQH_TRANSACTION_CATEGORIES

Line 262: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;

258: l_language varchar2(30) ;
259: --
260: l_attribute_id pqh_attributes.attribute_id%TYPE ;
261: l_table_route_id pqh_attributes.master_table_route_id%TYPE;
262: l_transaction_category_id pqh_transaction_categories.transaction_category_id%TYPE;
263: l_special_attribute_id pqh_special_attributes.special_attribute_id%TYPE := 0;
264: l_txn_category_attribute_id pqh_special_attributes.txn_category_attribute_id%TYPE;
265: --
266: l_created_by pqh_special_attributes.created_by%TYPE;

Line 286: from pqh_transaction_categories

282: and nvl(master_table_route_id,-999) = nvl(p_table_id, -999);
283: --
284: cursor cst_txn_cat_id(p_short_name IN VARCHAR2) is
285: select transaction_category_id
286: from pqh_transaction_categories
287: where short_name = p_short_name
288: and business_group_id is null;
289: --
290: --