APPS.PA_RATE_PVT_PKG dependencies on HR_LOCATIONS

Line 826: from hr_locations a, per_all_assignments_f b

822: from per_jobs_v
823: where job_id = pa_utils.getempjobid(X_person_id => p_person_id, X_date => p_rate_calc_date);
824: select location_code
825: into pa_pay_util.g_location_code
826: from hr_locations a, per_all_assignments_f b
827: where b.person_id = p_person_id
828: and a.location_use = 'HR'
829: and a.location_id = b.location_id
830: and p_rate_calc_date between b.effective_start_date and nvl(p_rate_calc_date, b.effective_end_date);

Line 2550: from hr_locations a, per_all_assignments_f b

2546: end if;
2547:
2548: select location_code
2549: into pa_pay_util.g_location_code
2550: from hr_locations a, per_all_assignments_f b
2551: where b.person_id = p_person_id
2552: and a.location_use = 'HR'
2553: and a.location_id = b.location_id
2554: and p_asgn_start_date between b.effective_start_date and nvl(p_asgn_start_date, b.effective_end_date);