3180: --
3181: hr_utility.set_location('pay_balance_upload.ins_latest_balance',10);
3182: select pay_latest_balances_s.nextval
3183: into l_lat_bal_id 3184: from sys.dual; 3185: --
3186: -- get bus grp id
3187: select distinct person_id,business_group_id
3188: into l_person_id,l_bus_grp_id