104: ,hr_locations loc
105: ,per_grades_vl grd
106: ,pay_payrolls_f pay
107: ,pay_people_groups pg
108: ,hr_lookups hl
109: ,hr_lookups hl1
110: where asg.assignment_id = :assignment_id
111: and :effective_date
112: between asg.effective_start_date and asg.effective_end_date
105: ,per_grades_vl grd
106: ,pay_payrolls_f pay
107: ,pay_people_groups pg
108: ,hr_lookups hl
109: ,hr_lookups hl1
110: where asg.assignment_id = :assignment_id
111: and :effective_date
112: between asg.effective_start_date and asg.effective_end_date
113: and asg.person_id = peo.person_id
220: , pay_balance_dimensions bd
221: , pay_balance_types_tl bt
222: , hr_organization_information oi
223: , pay_balance_types pbt
224: , hr_lookups hl
225: where bad.attribute_name = p_balance_attribute
226: and ( bad.BUSINESS_GROUP_ID IS NULL
227: OR bad.BUSINESS_GROUP_ID = l_business_group_id)
228: AND ( bad.LEGISLATION_CODE IS NULL