[Home] [Help]
294: where table_alias = p_table_alias;
295: --
296: cursor csr_txn_cat_att_id (p_attribute_id in number, p_transaction_category_id in number) is
297: select txn_category_attribute_id
298: from pqh_txn_category_attributes
299: where attribute_id = p_attribute_id
300: and transaction_category_id = p_transaction_category_id;
301: --
302: cursor csr_special_att_id(p_txn_category_attribute_id in number,
401: PER_RIC_PKG.chk_integrity (
402: p_entity_name=>'PQH_SPECIAL_ATTRIBUTES',
403: p_ref_entity_info=>
404: PER_RIC_PKG.ref_entity_tbl(
405: PER_RIC_PKG.ref_info_rec('PQH_TXN_CATEGORY_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
406: PER_RIC_PKG.col_info_rec('TXN_CATEGORY_ATTRIBUTE_ID',NULL,l_txn_category_attribute_id, NULL))),
407: PER_RIC_PKG.ref_info_rec('PQH_COPY_ENTITY_CONTEXTS',PER_RIC_PKG.column_info_tbl(
408: PER_RIC_PKG.col_info_rec('CONTEXT',p_context,NULL, NULL)))),
409: p_ref_type=>'INS');