APPS.BEN_EXT_FMT dependencies on PER_ALL_ASSIGNMENTS_F

Line 3471: from per_all_assignments_f asg,hr_locations_all loc

3467: l_rule_type c_rule_type%rowtype;
3468:
3469: cursor c_asg is
3470: select asg.assignment_id,asg.organization_id,loc.region_2
3471: from per_all_assignments_f asg,hr_locations_all loc
3472: where asg.person_id = p_person_id
3473: and (asg.primary_flag = 'Y' OR asg.assignment_type = 'A')
3474: and asg.assignment_id = nvl(ben_ext_person.g_assignment_id,asg.assignment_id) --1969853
3475: and asg.location_id = loc.location_id(+)