35: ,hr_locations loc
36: ,per_grades_vl grd
37: ,pay_payrolls_f pay
38: ,pay_people_groups pg
39: ,hr_lookups hl
40: ,hr_soft_coding_keyflex soft
41: ,(SELECT ppb2.pay_basis_id
42: ,ppb2.business_group_id
43: ,ee.assignment_id
166: , pay_balance_dimensions bd
167: , pay_balance_types_tl bt
168: , hr_organization_information oi
169: , pay_balance_types pbt
170: , hr_lookups hl
171: where bad.attribute_name = p_balance_attribute
172: and ( bad.BUSINESS_GROUP_ID IS NULL
173: OR bad.BUSINESS_GROUP_ID = l_business_group_id)
174: AND ( bad.LEGISLATION_CODE IS NULL