DBA Data[Home] [Help]

APPS.BENUTILS dependencies on HR_LOCATIONS_ALL

Line 4149: from per_all_assignments_f asg,hr_locations_all loc

4145: -- US legislation code.
4146: --
4147: cursor c_asg is
4148: select asg.assignment_id,asg.organization_id,loc.region_2
4149: from per_all_assignments_f asg,hr_locations_all loc
4150: where asg.assignment_id = p_assignment_id
4151: and asg.primary_flag = 'Y'
4152: and asg.location_id = loc.location_id(+)
4153: and p_effective_date

Line 4605: l_loc_rec hr_locations_all%rowtype;

4601: --Bug# 12664112
4602:
4603: l_package varchar2(80) := g_package||'.run_rule';
4604: l_outputs ff_exec.outputs_t;
4605: l_loc_rec hr_locations_all%rowtype;
4606: l_ass_rec per_all_assignments_f%rowtype;
4607: l_jurisdiction_code varchar2(30);
4608: l_env ben_env_object.g_global_env_rec_type;
4609: --