DBA Data[Home] [Help]

APPS.PQH_RLS_BUS dependencies on PQH_TRANSACTION_CATEGORIES

Line 712: pqh_transaction_categories ptc

708: cursor c_txn_cats(p_role_id number) is
709: select distinct ptc.transaction_category_id, ptc.name transaction_category,
710: ptc.business_group_id
711: from pqh_routing_list_members rlm, pqh_routing_categories rct,
712: pqh_transaction_categories ptc
713: where rlm.routing_list_id = rct.routing_list_id
714: and rlm.role_id = p_role_id
715: and rct.transaction_category_id=ptc.transaction_category_id;
716: --