APPS.JAI_RCV_UTILS_PKG dependencies on HR_LOCATIONS

Line 159: FROM hr_locations

155: v_rg_location_id := 0;
156: ELSIF p_location_id IS NOT NULL
157: THEN
158: For hr_rec IN (SELECT inventory_organization_id org
159: FROM hr_locations
160: WHERE location_id = p_location_id)
161: LOOP
162: v_organization_id := NVL(hr_rec.org, 0);
163: END LOOP;