206: /* ------------------ CURSORS ---------------------- */
207: /* Cursor used retrieve the hazard classification codes */
208: CURSOR c_get_hazard_classes IS
209: SELECT *
210: FROM gr_property_values_tl
211: WHERE language = userenv('LANG') and
212: property_id = 'UNCLSS';
213: l_hazard_class_rec c_get_hazard_classes%ROWTYPE;
214:
227:
228: /* Cursor used to retrieve translated descriptions for installed languages */
229: CURSOR c_get_translated (v_hazard_class VARCHAR2) IS
230: SELECT *
231: FROM gr_property_values_tl
232: WHERE language in (SELECT language_code
233: FROM fnd_languages
234: WHERE language_code <> userenv('LANG')
235: AND installed_flag in ('I','B'))