APPS.BEN_ELECTION_INFORMATION dependencies on HR_LOCATIONS_ALL

Line 4501: FROM hr_locations_all loc, per_all_assignments_f asg

4497: asg.effective_start_date and asg.effective_end_date;
4498:
4499: CURSOR c_state IS
4500: SELECT loc.region_2
4501: FROM hr_locations_all loc, per_all_assignments_f asg
4502: WHERE loc.location_id = asg.location_id
4503: AND asg.person_id = p_person_id
4504: and asg.assignment_type <> 'C'
4505: AND asg.primary_flag = 'Y'