APPS.PQH_RLM_BUS dependencies on PQH_TRANSACTION_CATEGORIES

Line 660: pqh_transaction_categories ptc

656: cursor c_txn_cats(p_routing_list_id number) is
657: select distinct ptc.transaction_category_id, ptc.name transaction_category_name,
658: ptc.business_group_id
659: from pqh_routing_list_members rlm, pqh_routing_categories rct,
660: pqh_transaction_categories ptc
661: where rlm.routing_list_id = rct.routing_list_id
662: and rct.routing_list_id = p_routing_list_id
663: and rct.transaction_category_id = ptc.transaction_category_id;
664: --

Line 698: from pqh_transaction_categories_vl

694: l_freeze_status varchar2(30);
695: --
696: cursor c_cat_status(p_transaction_category_id number) is
697: select freeze_status_cd
698: from pqh_transaction_categories_vl
699: where transaction_category_id = p_transaction_category_id;
700: --
701: begin
702: --