APPS.BEN_DETERMINE_DATE dependencies on HR_LOCATIONS_ALL

Line 717: from hr_locations_all loc,per_all_assignments_f asg

713: order by decode(asg.assignment_type,'E',1,2) asc;
714: --
715: Cursor c_state is
716: select region_2
717: from hr_locations_all loc,per_all_assignments_f asg
718: where loc.location_id = asg.location_id
719: and asg.person_id = p_person_id
720: and asg.assignment_type <> 'C'
721: and p_effective_date between