APPS.PQH_TEM_SHD dependencies on PQH_TRANSACTION_CATEGORIES

Line 334: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;

330: l_language varchar2(30) ;
331:
332: --
333: l_template_id pqh_templates.template_id%type := 0;
334: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
335: --
336: --
337: l_created_by pqh_templates.created_by%TYPE;
338: l_last_updated_by pqh_templates.last_updated_by%TYPE;

Line 347: from pqh_transaction_categories

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
349: and business_group_id is null;
350: --
351: Cursor c3 is select template_id