DBA Data[Home] [Help]

APPS.PQH_RLM_BUS dependencies on PQH_ROUTING_CATEGORIES

Line 659: from pqh_routing_list_members rlm, pqh_routing_categories rct,

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

Line 717: from pqh_attribute_ranges arg, pqh_routing_categories rtc

713: l_api_updating boolean;
714: --
715: cursor c_txn_cats(p_routing_list_member_id number) is
716: select distinct rtc.transaction_category_id
717: from pqh_attribute_ranges arg, pqh_routing_categories rtc
718: where routing_list_member_id = p_routing_list_member_id
719: and arg.routing_category_id = rtc.routing_category_id;
720:
721: --