APPS.PQH_SIT_ENGINE dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 11: from pqh_txn_category_attributes

7: l_value_style_cd Varchar2(30);
8: begin
9: select attribute_id, value_style_cd
10: into l_attribute_id, l_value_style_cd
11: from pqh_txn_category_attributes
12: where txn_category_attribute_id = p_txn_catg_attr_id;
13: hr_utility.set_location('attr : '||l_attribute_id, 5);
14: hr_utility.set_location('l_value_style_cd : '||l_value_style_cd, 5);
15: p_attribute_id := l_attribute_id;

Line 236: l_value_style_cd pqh_txn_category_attributes.value_style_cd%type;

232: l_rule_message fnd_new_messages.message_text%type;
233: l_attribute_id number;
234: l_required_flag varchar2(2);
235: l_exclude_flag varchar2(2);
236: l_value_style_cd pqh_txn_category_attributes.value_style_cd%type;
237:
238: cursor csr_sit_rules (p_required_flag VARCHAR2) is
239: select * from pqh_fr_stat_situation_rules
240: where statutory_situation_id = p_stat_sit_id