APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on HR_LOCATIONS_ALL

Line 256: l_region_2 hr_locations_all.region_2%type;

252: l_apld_eligible_flag varchar2(30) := 'Y';
253: l_inelig_rsn_cd varchar2(30) := null;
254: l_assignment_id number;
255: l_organization_id number;
256: l_region_2 hr_locations_all.region_2%type;
257: l_outputs ff_exec.outputs_t;
258: l_jurisdiction_code varchar2(30);
259: l_effective_date date ;
260: --

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'