DBA Data[Home] [Help]

APPS.PQH_ATTRIBUTE_RANGES_PKG dependencies on PQH_ATTRIBUTES_VL

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;