APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on HR_LOCATIONS_ALL

Line 249: l_region_2 hr_locations_all.region_2%type;

245: l_apld_eligible_flag varchar2(30) := 'Y';
246: l_inelig_rsn_cd varchar2(30) := null;
247: l_assignment_id number;
248: l_organization_id number;
249: l_region_2 hr_locations_all.region_2%type;
250: l_outputs ff_exec.outputs_t;
251: l_jurisdiction_code varchar2(30);
252: l_effective_date date ;
253: --

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'