APPS.PQH_BDGT_REALLOC_UTILITY dependencies on WF_ITEMS

Line 1171: From wf_items

1167: Where pool_id = p_transaction_id;
1168:
1169: Cursor csr_seq_no (l_transaction_category_id IN number) IS
1170: Select max(substr(item_key,(length(l_transaction_category_id||'-'||p_transaction_id))+2,6) )
1171: From wf_items
1172: Where item_type='PQHGEN'
1173: And item_key like l_transaction_category_id||'-'||p_transaction_id||'%';
1174:
1175: l_proc varchar2(72) := g_package||'notify_bgt_manager_users';