APPS.PQH_RLT_BUS dependencies on PQH_TRANSACTION_CATEGORIES_VL

Line 171: l_name pqh_transaction_categories_vl.name%type;

167: -- Internal table handler use only.
168: --
169: Procedure chk_for_pending_txns(p_routing_list_id in number) is
170: --
171: l_name pqh_transaction_categories_vl.name%type;
172: l_proc varchar2(72) := g_package||'chk_for_pending_txns';
173: l_bus_grp_name varchar2(240);
174: l_bus_grp_id pqh_transaction_categories_vl.business_group_id%type;
175: l_api_updating boolean;

Line 174: l_bus_grp_id pqh_transaction_categories_vl.business_group_id%type;

170: --
171: l_name pqh_transaction_categories_vl.name%type;
172: l_proc varchar2(72) := g_package||'chk_for_pending_txns';
173: l_bus_grp_name varchar2(240);
174: l_bus_grp_id pqh_transaction_categories_vl.business_group_id%type;
175: l_api_updating boolean;
176: --
177: cursor c_txn_cats(p_routing_list_id number) is
178: select distinct transaction_category_id

Line 185: From pqh_transaction_categories_vl

181: and rct.routing_list_id = p_routing_list_id;
182: --
183: Cursor csr_txn_cat_name(p_transaction_category_id in number) is
184: Select name,business_group_id
185: From pqh_transaction_categories_vl
186: Where transaction_category_id = p_transaction_category_id;
187: --
188: Begin
189: --