APPS.BEN_PLAN_COPY_LOADER dependencies on PQH_TRANSACTION_CATEGORIES

Line 192: from pqh_transaction_categories tc

188: -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date ;
189: --
190: cursor c2 is
191: select transaction_category_id
192: from pqh_transaction_categories tc
193: where tc.short_name = p_TRANS_CATEGORY_NAME ;
194: --
195: cursor c3 is
196: select business_group_id

Line 457: from pqh_transaction_categories tc

453: -- Bug : 4354708
454: --
455: cursor c2 is
456: select transaction_category_id
457: from pqh_transaction_categories tc
458: where tc.short_name = p_TRANS_CATEGORY_NAME ;
459: --
460: cursor c1(v_context_business_group_id number, v_transaction_category_id number) is
461: select null

Line 900: from pqh_transaction_categories tc

896: l_install_status varchar2(100);
897: -- Bug : 4354708
898: cursor c2 is
899: select transaction_category_id
900: from pqh_transaction_categories tc
901: where tc.short_name = p_TRANS_CATEGORY_NAME ;
902: --
903: cursor c1(v_context_business_group_id number, v_transaction_category_id number) is
904: select null

Line 1863: from pqh_transaction_categories tc

1859: l_install_status varchar2(100);
1860: -- Bug : 4354708
1861: cursor c2 is
1862: select transaction_category_id
1863: from pqh_transaction_categories tc
1864: where tc.short_name = g_TRANS_CATEGORY_NAME ;
1865: --
1866: cursor c3(v_context_business_group_id number, v_transaction_category_id number) is
1867: select copy_entity_txn_id