APPS.PQH_TAT_BUS dependencies on PQH_ATTRIBUTES_VL

Line 191: l_attribute_name pqh_attributes_vl.attribute_name%type;

187: --
188: l_api_updating boolean;
189: l_dummy varchar2(1);
190: l_enable_flag pqh_attributes.enable_flag%type;
191: l_attribute_name pqh_attributes_vl.attribute_name%type;
192: --
193: cursor c1 is
194: select nvl(enable_flag,'N')
195: from pqh_attributes a

Line 200: from pqh_attributes_vl att,pqh_template_attributes tat

196: where a.attribute_id = p_attribute_id;
197: --
198: Cursor c2 is
199: select att.attribute_name
200: from pqh_attributes_vl att,pqh_template_attributes tat
201: where tat.attribute_id = p_attribute_id
202: and tat.template_id = p_template_id
203: and tat.attribute_id = att.attribute_id;
204: --

Line 384: from pqh_attributes_vl

380: where template_id = p_template_id;
381: --
382: cursor c_attribute_leg_code is
383: select legislation_code, attribute_name
384: from pqh_attributes_vl
385: where attribute_id = p_attribute_id;
386: --
387: Begin
388: --