APPS.PQH_FR_STAT_SIT_UTIL dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 131: from pqh_txn_category_attributes

127: --
128: --
129: Cursor csr_get_txn_record IS
130: Select value_style_cd, value_set_id
131: from pqh_txn_category_attributes
132: where txn_category_attribute_id = p_txn_category_attribute_id;
133: --
134: --
135: l_query varchar2(5000) := 'select null Id, null Val,null Att_Name from dual Where 1 = 2';

Line 136: l_value_style_cd pqh_txn_category_attributes.value_style_cd%type;

132: where txn_category_attribute_id = p_txn_category_attribute_id;
133: --
134: --
135: l_query varchar2(5000) := 'select null Id, null Val,null Att_Name from dual Where 1 = 2';
136: l_value_style_cd pqh_txn_category_attributes.value_style_cd%type;
137: l_value_set_id pqh_txn_category_attributes.value_set_id%type;
138: l_ret varchar2(10);
139: l_validation_type varchar2(10);
140: --

Line 137: l_value_set_id pqh_txn_category_attributes.value_set_id%type;

133: --
134: --
135: l_query varchar2(5000) := 'select null Id, null Val,null Att_Name from dual Where 1 = 2';
136: l_value_style_cd pqh_txn_category_attributes.value_style_cd%type;
137: l_value_set_id pqh_txn_category_attributes.value_set_id%type;
138: l_ret varchar2(10);
139: l_validation_type varchar2(10);
140: --
141: begin

Line 419: FROM pqh_txn_category_attributes tca,

415: tr.from_clause,
416: tr.where_clause,
417: a.column_name,
418: a.column_type
419: FROM pqh_txn_category_attributes tca,
420: pqh_table_route tr,
421: pqh_attributes a
422: WHERE tca.txn_category_attribute_id = p_txn_catg_attribute_id
423: AND tca.attribute_id = a.attribute_id