DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on PER_ALL_ASSIGNMENTS_F

Line 617: from per_all_assignments_f asg,hr_locations_all loc

613: (c_effective_date in date
614: )
615: is
616: select asg.assignment_id,asg.organization_id,loc.region_2
617: from per_all_assignments_f asg,hr_locations_all loc
618: where asg.person_id = l_contact.person_id
619: and asg.assignment_type <> 'C'
620: and asg.location_id = loc.location_id(+)
621: and asg.primary_flag='Y'