APPS.PQH_RNG_BUS dependencies on PQH_TRANSACTION_CATEGORIES

Line 185: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;

181: l_proc varchar2(72) := g_package||'chk_routing_category_id';
182: l_api_updating boolean;
183: l_dummy varchar2(1);
184: l_tcat pqh_routing_categories.transaction_category_id%type;
185: l_freeze_status_cd pqh_transaction_categories.freeze_status_cd%type;
186: --
187: cursor c1 is
188: -- select null
189: select transaction_category_id

Line 195: from pqh_transaction_categories a

191: where a.routing_category_id = p_routing_category_id;
192: --
193: cursor c2 is
194: select nvl(freeze_status_cd,hr_api.g_varchar2)
195: from pqh_transaction_categories a
196: where a.transaction_category_id = l_tcat;
197: Begin
198: --
199: hr_utility.set_location('Entering:'||l_proc,5);