APPS.BEN_ENROLLMENT_ACTION_ITEMS dependencies on HR_LOCATIONS_ALL

Line 3214: from hr_locations_all loc,per_all_assignments_f asg

3210: l_asg c_asg%rowtype;
3211:
3212: Cursor c_state is
3213: select region_2
3214: from hr_locations_all loc,per_all_assignments_f asg
3215: where loc.location_id = asg.location_id
3216: and asg.person_id = l_rslt.person_id
3217: and asg.assignment_type <> 'C'
3218: and p_effective_date between