Line 672: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
668: --
669: for r_txn_cat in c_txn_cats(p_routing_list_id)
670: loop
671: -- 672: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N') 673: = 'Y' then
674: hr_utility.set_message(8302,'PQH_CANT_DEL_RLM_PNDG_TXN');
675: hr_utility.set_message_token('TRANSACTION_CATEGORY', r_txn_cat.transaction_category_name);
676: if (r_txn_cat.business_group_id is not null) then