DBA Data[Home] [Help]

APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on PER_ALL_ASSIGNMENTS_F

Line 609: from per_all_assignments_f asg,hr_locations_all loc

605: (c_effective_date in date
606: )
607: is
608: select asg.assignment_id,asg.organization_id,loc.region_2
609: from per_all_assignments_f asg,hr_locations_all loc
610: where asg.person_id = l_contact.person_id
611: and asg.assignment_type <> 'C'
612: and asg.location_id = loc.location_id(+)
613: and asg.primary_flag='Y'