APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on HR_LOCATIONS_ALL

Line 1111: from hr_locations_all loc,per_all_assignments_f asg

1107: paf.effective_start_date and paf.effective_end_date;
1108:
1109: Cursor c_state is
1110: select region_2
1111: from hr_locations_all loc,per_all_assignments_f asg
1112: where loc.location_id = asg.location_id
1113: and asg.person_id = p_person_id
1114: and asg.primary_flag = 'Y'
1115: and p_effective_date between