APPS.PAY_GB_ENROLL_PENSION dependencies on HR_LOCATIONS_ALL

Line 1803: hr_locations_all l

1799: CURSOR c_location(p_location VARCHAR2)
1800: IS
1801: SELECT 1
1802: FROM per_all_assignments_f a,
1803: hr_locations_all l
1804: WHERE assignment_id=p_assignment_id
1805: AND a.LOCATION_ID = l.LOCATION_ID
1806: AND l.location_code=p_location
1807: AND G_PRP_END_DATE BETWEEN a.effective_start_date AND a.effective_end_date;