DBA Data[Home] [Help]

APPS.BEN_EXT_FMT dependencies on HR_LOCATIONS_ALL

Line 3477: from per_all_assignments_f asg,hr_locations_all loc

3473: l_rule_type c_rule_type%rowtype;
3474:
3475: cursor c_asg is
3476: select asg.assignment_id,asg.organization_id,loc.region_2
3477: from per_all_assignments_f asg,hr_locations_all loc
3478: where asg.person_id = p_person_id
3479: and (asg.primary_flag = 'Y' OR asg.assignment_type = 'A')
3480: and asg.assignment_id = nvl(ben_ext_person.g_assignment_id,asg.assignment_id) --1969853
3481: and asg.location_id = loc.location_id(+)