APPS.RCV_TRANSACTIONS_INTERFACE_SV dependencies on HR_LOCATIONS

Line 405: FROM hr_locations hl,

401:
402: IF (x_cascaded_table(n).ship_to_location_code IS NOT NULL) THEN
403: SELECT MAX(org.organization_code)
404: INTO x_to_organization_code
405: FROM hr_locations hl,
406: mtl_parameters org -- Bugfix 5217098
407: WHERE x_cascaded_table(n).ship_to_location_code = hl.location_code
408: AND hl.inventory_organization_id = org.organization_id;
409:

Line 3871: FROM hr_locations

3867: ) IS
3868: BEGIN
3869: SELECT MAX(location_id)
3870: INTO x_location_id_record.location_id
3871: FROM hr_locations
3872: WHERE location_code = x_location_id_record.location_code;
3873:
3874: IF (x_location_id_record.location_id IS NULL) THEN
3875: x_location_id_record.error_record.error_status := rcv_error_pkg.g_ret_sts_error;

Line 4437: FROM hr_locations

4433: ) IS
4434: BEGIN
4435: SELECT inventory_organization_id
4436: INTO x_organization_id
4437: FROM hr_locations
4438: WHERE location_id = p_hr_location_id;
4439: EXCEPTION
4440: WHEN OTHERS THEN
4441: x_organization_id := NULL;