APPS.BEN_DISTRIBUTE_RATES dependencies on HR_LOCATIONS_ALL

Line 4429: from hr_locations_all loc, per_all_assignments_f asg

4425:
4426: cursor get_asg_info is
4427: select asg.assignment_id, asg.organization_id, loc.region_2 state, asg.location_id,
4428: asg.payroll_id
4429: from hr_locations_all loc, per_all_assignments_f asg
4430: where asg.person_id = p_person_id
4431: and asg.assignment_type <> 'C'
4432: and asg.primary_flag = 'Y'
4433: and loc.location_id(+) = asg.location_id