APPS.INV_LABEL_PVT8 dependencies on HR_LOCATIONS_ALL_V

Line 911: , hr_locations_all_v loc

907: SELECT hou.name organization_name
908: , loc.telephone_number_1 org_tel_num
909: , loc.telephone_number_2 org_fax_num
910: FROM hr_organization_units hou
911: , hr_locations_all_v loc
912: WHERE hou.organization_id = p_organization_id
913: AND hou.location_id = loc.location_id (+);
914:
915: