I first should ask you why you are asking.... is there a particular concern you have? If so, I'm sure you can discuss with your local SSI Dealer.
In regards to your question: In the USA training standards (Includes Canada), the definition of "Open Water" in SSI's standards is:
15. Definition Open Water: Open water is any body of water other than a swimming pool. Open water sites are to be realistic of local diving conditions.
So - certainly inland quarries and lakes are acceptable (otherwise I'd be travelling a loooong way to certify students
) Having said this, it is always recognized that training in one environment does not necessarily suggest that you are competent in another and students are coached to ensure they take the time to get a safe orientation to differing conditions. As an example we often have students who have certified somewhere in warm salt water with 100' vis take a cold water orientation to get used to the bulk of a 7mil wetsuit, hood, buoyancy swing casued by the gear, heavy weights required, lower vis., temperatures... etc.
Also please recognize that this definition is not complete out of context. Each specific course may have specific dive requirements that may have a bearing on what locations may be considered appropriate. It is ultimately up to an instructor to be comfortable that the location used provides an appropriate and reasonable representation of local conditions.
e.g. Open Water requirements further outline:
7. Number of Dives: All four open water scuba training dives must be conducted at depths between 15 and 60 feet (5 and 18 meters). ............ etc etc...........
All students even after certification should be advised only to dive within depth limits they are taught in during class.
Hope this helps..... If there is a particular purpose to your inquiry it would be helpful if you would outline it.