3473: --
3474: hr_utility.set_location('pay_balance_upload.ins_latest_balance',10);
3475: select pay_latest_balances_s.nextval
3476: into l_lat_bal_id 3477: from sys.dual; 3478: --
3479: -- get bus grp id
3480: select distinct person_id,business_group_id
3481: into l_person_id,l_bus_grp_id