DBA Data[Home] [Help]

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