305: CURSOR csr_bg IS
306: select hou.business_group_id,
307: hou.legislation_code
308: from per_business_groups hou,
309: pay_balance_batch_headers bbh
310: where bbh.batch_id = p_batch_id
311: and upper(hou.name) = upper(bbh.business_group_name);
312:
313: cursor c_each_batch (c_batch_id number) is
429: SELECT pbg.business_group_id
430: ,bbh.business_group_name
431: ,pbg.currency_code
432: ,pbg.legislation_code
433: FROM pay_balance_batch_headers bbh
434: ,per_business_groups pbg
435: WHERE batch_id = p_batch_id
436: AND upper(pbg.name) = upper(bbh.business_group_name);
437: