APPS.PAY_BALANCE_UPLOAD dependencies on HR_LOCATIONS_ALL
Line 2086: from hr_locations_all LOC
2082:
2083: CURSOR c_assignment_jur
2084: IS
2085: SELECT LOC.region_1 2086: from hr_locations_all LOC 2087: , per_all_assignments_f ASSIGN
2088: where p_effective_date BETWEEN ASSIGN.effective_start_date
2089: AND ASSIGN.effective_end_date
2090: and ASSIGN.assignment_id = p_asg_id