32: --
33: -- HISTORY
34: -- 25-Oct-2002 GPAGADAL Created
35: -- 07-Feb-2003 GPAGADAL updated- Change the queryin the procedure so that it
36: -- uses cct_classification_values instead of cct view
37:
38: --====================================================================
39:
40: PROCEDURE GET_MEDIA_CLASS_LIST (p_media_type_id IN number,
48:
49:
50: CURSOR c_mclsfn IS
51: select unique(cv.CLASSIFICATION_VALUE) classification_value, null label
52: from cct_classification_values cv
53: order by lower(cv.CLASSIFICATION_VALUE);
54:
55:
56: i integer := 0;