APPS.PQH_TAT_BUS dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 305: l_select_flag pqh_txn_category_attributes.select_flag%type;

301: l_proc varchar2(72) := g_package||'chk_att_tct';
302: l_api_updating boolean;
303: l_dummy varchar2(1);
304: l_tem_tct pqh_templates.transaction_category_id%type;
305: l_select_flag pqh_txn_category_attributes.select_flag%type;
306: --
307: cursor c1 is
308: select transaction_category_id
309: from pqh_templates a

Line 314: from pqh_attributes att , pqh_txn_category_attributes tca

310: where a.template_id = p_template_id;
311: --
312: cursor c2 is
313: select nvl(tca.select_flag,'N')
314: from pqh_attributes att , pqh_txn_category_attributes tca
315: where att.attribute_id = p_attribute_id
316: AND att.attribute_id = tca.attribute_id
317: AND tca.transaction_category_id = l_tem_tct;
318: Begin