DBA Data[Home] [Help]

APPS.PQH_RTM_BUS dependencies on PQH_ROUTING_CATEGORIES

Line 404: from pqh_routing_list_members rlm, pqh_routing_categories rct,

400: --
401: cursor c_txn_cats(p_role_id number) is
402: select distinct ptc.transaction_category_id, ptc.name transaction_category,
403: ptc.business_group_id
404: from pqh_routing_list_members rlm, pqh_routing_categories rct,
405: pqh_transaction_categories ptc
406: where rlm.routing_list_id = rct.routing_list_id
407: and rlm.role_id = p_role_id
408: and rct.transaction_category_id=ptc.transaction_category_id;