840: -- for a transaction category.
841: --
842: Cursor csr_list_ident_defined is
843: Select count(*)
844: From pqh_txn_category_attributes
845: Where transaction_category_id = p_transaction_category_id
846: AND list_identifying_flag = 'Y';
847: --
848: --
1304: p_max_list_identifiers in number,
1305: p_max_member_identifiers in number) is
1306: --
1307: Cursor tot_list_identifiers is
1308: Select count(*) from pqh_txn_category_attributes tca
1309: where tca.transaction_category_id = p_transaction_category_id
1310: AND tca.list_identifying_flag = 'Y';
1311: --
1312: Cursor tot_member_identifiers is
1309: where tca.transaction_category_id = p_transaction_category_id
1310: AND tca.list_identifying_flag = 'Y';
1311: --
1312: Cursor tot_member_identifiers is
1313: Select count(*) from pqh_txn_category_attributes tca
1314: where tca.transaction_category_id = p_transaction_category_id
1315: AND tca.member_identifying_flag = 'Y';
1316: --
1317: l_no_list_identifiers number(5);