135: , ppf.business_group_id per_bg
136: , nvl(pbh.business_group_id,-1) batch_bg
137: , ppr.business_group_id pay_bg
138: FROM hxt_timecards tim
139: , per_people_f ppf
140: , pay_payrolls ppr
141: , pay_batch_headers pbh
142: , per_time_periods ptp
143: WHERE tim.for_person_id = ppf.person_id