APPS.PQH_RLS_BUS dependencies on PQH_ROUTING_CATEGORIES

Line 711: from pqh_routing_list_members rlm, pqh_routing_categories rct,

707: --
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;

Line 759: from pqh_routing_list_members rlm, pqh_routing_categories rct

755: l_api_updating boolean;
756: --
757: cursor c_txn_cats(p_role_id number, p_user_id number) is
758: select distinct transaction_category_id
759: from pqh_routing_list_members rlm, pqh_routing_categories rct
760: where (rlm.routing_list_id = rct.routing_list_id
761: and rlm.user_id = p_user_id
762: and rlm.role_id = p_role_id)
763: or (rct.override_user_id = p_user_id and rct.override_role_id = p_role_id) ;