APPS.PQH_RLS_BUS dependencies on PQH_TCT_BUS

Line 724: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')

720: --
721: for r_txn_cat in c_txn_cats(p_role_id)
722: loop
723: --
724: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
725: = 'Y' then
726: --
727: hr_utility.set_message(8302,'PQH_CANT_DEL_RLS_PNDG_TXN');
728: hr_utility.set_message_token('TRANSACTION_CATEGORY', r_txn_cat.transaction_category);

Line 772: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')

768: --
769: for r_txn_cat in c_txn_cats(p_role_id, p_user_id)
770: loop
771: --
772: if nvl(pqh_tct_bus.chk_active_transaction_exists(r_txn_cat.transaction_category_id),'N')
773: = 'Y' then
774: hr_utility.set_message(8302,'PQH_CANT_DEL_USR_PNDG_TXN');
775: hr_utility.raise_error;
776: end if;