APPS.BEN_ELECTION_INFORMATION dependencies on HR_LOCATIONS_ALL

Line 4004: FROM hr_locations_all loc, per_all_assignments_f asg

4000: asg.effective_start_date and asg.effective_end_date;
4001:
4002: CURSOR c_state IS
4003: SELECT loc.region_2
4004: FROM hr_locations_all loc, per_all_assignments_f asg
4005: WHERE loc.location_id = asg.location_id
4006: AND asg.person_id = p_person_id
4007: and asg.assignment_type <> 'C'
4008: AND asg.primary_flag = 'Y'