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