DBA Data[Home] [Help]

APPS.BENUTILS dependencies on HR_LOCATIONS_ALL

Line 4053: from per_all_assignments_f asg,hr_locations_all loc

4049: -- US legislation code.
4050: --
4051: cursor c_asg is
4052: select asg.assignment_id,asg.organization_id,loc.region_2
4053: from per_all_assignments_f asg,hr_locations_all loc
4054: where asg.assignment_id = p_assignment_id
4055: and asg.primary_flag = 'Y'
4056: and asg.location_id = loc.location_id(+)
4057: and p_effective_date

Line 4493: l_loc_rec hr_locations_all%rowtype;

4489: --
4490:
4491: l_package varchar2(80) := g_package||'.run_rule';
4492: l_outputs ff_exec.outputs_t;
4493: l_loc_rec hr_locations_all%rowtype;
4494: l_ass_rec per_all_assignments_f%rowtype;
4495: l_jurisdiction_code varchar2(30);
4496: l_env ben_env_object.g_global_env_rec_type;
4497: --