Line 417: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
413: --
414: for r_txn_cat in c_txn_cats(p_role_id)
415: loop
416: -- 417: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N') 418: = 'Y' then
419: --
420: p_txn_cat := r_txn_cat.transaction_category;
421: if (r_txn_cat.business_group_id is not null) then