30: ,hr_locations loc
31: ,per_grades_vl grd
32: ,pay_payrolls_f pay
33: ,pay_people_groups pg
34: ,hr_lookups hl
35: ,hr_lookups hl1
36: where asg.assignment_id = :assignment_id
37: and :effective_date
38: between asg.effective_start_date and asg.effective_end_date
31: ,per_grades_vl grd
32: ,pay_payrolls_f pay
33: ,pay_people_groups pg
34: ,hr_lookups hl
35: ,hr_lookups hl1
36: where asg.assignment_id = :assignment_id
37: and :effective_date
38: between asg.effective_start_date and asg.effective_end_date
39: and asg.person_id = peo.person_id
149: , pay_balance_dimensions bd
150: , pay_balance_types_tl bt
151: , hr_organization_information oi
152: , pay_balance_types pbt
153: , hr_lookups hl
154: where bad.attribute_name = p_balance_attribute
155: and ( bad.BUSINESS_GROUP_ID IS NULL
156: OR bad.BUSINESS_GROUP_ID = l_business_group_id)
157: AND ( bad.LEGISLATION_CODE IS NULL