APPS.PQH_ATTRIBUTE_RANGES_PKG dependencies on PQH_TXN_CATEGORY_ATTRIBUTES

Line 78: from pqh_txn_category_attributes tca,pqh_attributes_vl att

74: --
75: Cursor c1 is
76: select att.attribute_name,tca.attribute_id,
77: att.column_type,tca.value_style_cd,tca.value_set_id
78: from pqh_txn_category_attributes tca,pqh_attributes_vl att
79: where tca.transaction_category_id = p_transaction_category_id
80: and tca.attribute_id = att.attribute_id
81: and tca.list_identifying_flag='Y'
82: order by tca.attribute_id;

Line 87: from pqh_txn_category_attributes tca,pqh_attributes_vl att

83: --
84: Cursor c2 is
85: select att.attribute_name,tca.attribute_id,
86: att.column_type,tca.value_style_cd,tca.value_set_id
87: from pqh_txn_category_attributes tca,pqh_attributes_vl att
88: where tca.transaction_category_id = p_transaction_category_id
89: and tca.attribute_id = att.attribute_id
90: and tca.member_identifying_flag='Y'
91: order by tca.attribute_id;

Line 1282: from pqh_txn_category_attributes

1278: Where transaction_category_id = p_transaction_category_id;
1279: --
1280: Cursor csr_list_ident_cnt is
1281: Select count(*)
1282: from pqh_txn_category_attributes
1283: Where transaction_category_id = p_transaction_category_id
1284: AND list_identifying_flag = 'Y';
1285: --
1286: l_proc varchar2(72) := g_package||'chk_enable_routing_category';

Line 1663: from pqh_txn_category_attributes

1659: Where transaction_category_id = p_transaction_category_id;
1660: --
1661: Cursor csr_mem_ident_cnt is
1662: Select count(*)
1663: from pqh_txn_category_attributes
1664: Where transaction_category_id = p_transaction_category_id
1665: AND member_identifying_flag = 'Y';
1666: --
1667: l_proc varchar2(72) := g_package||'chk_mem_overlap_on_freeze';