APPS.BEN_DISTRIBUTE_RATES dependencies on HR_LOCATIONS_ALL

Line 4749: from hr_locations_all loc, per_all_assignments_f asg

4745:
4746: cursor get_asg_info is
4747: select asg.assignment_id, asg.organization_id, loc.region_2 state, asg.location_id,
4748: asg.payroll_id
4749: from hr_locations_all loc, per_all_assignments_f asg
4750: where asg.person_id = p_person_id
4751: and asg.assignment_type <> 'C'
4752: and asg.primary_flag = 'Y'
4753: and loc.location_id(+) = asg.location_id