5872: --Bug 4945193 Cursor to retreive the transaction category
5873: cursor c_trasaction_categories is
5874: select ptc.short_name
5875: from PQH_COPY_ENTITY_TXNS pcet,
5876: PQH_TRANSACTION_CATEGORIES ptc
5877: where pcet.COPY_ENTITY_TXN_ID= p_copy_entity_txn_id
5878: and ptc.TRANSACTION_CATEGORY_ID = pcet.TRANSACTION_CATEGORY_ID;
5879:
5880: l_trasaction_category PQH_TRANSACTION_CATEGORIES.SHORT_NAME%type;
5876: PQH_TRANSACTION_CATEGORIES ptc
5877: where pcet.COPY_ENTITY_TXN_ID= p_copy_entity_txn_id
5878: and ptc.TRANSACTION_CATEGORY_ID = pcet.TRANSACTION_CATEGORY_ID;
5879:
5880: l_trasaction_category PQH_TRANSACTION_CATEGORIES.SHORT_NAME%type;
5881: -- End Bug 4945193
5882:
5883: begin
5884: --