1202: p_version_number NUMBER,
1203: p_assessment_type VARCHAR2)IS
1204: SELECT grading_schema_cd,
1205: gs_version_number
1206: FROM igs_as_appr_grd_sch
1207: WHERE unit_cd = p_unit_cd AND
1208: version_number = p_version_number AND
1209: assessment_type = p_assessment_type AND
1210: default_ind = 'Y' AND
1214: CURSOR cur_get_appr (p_unit_cd VARCHAR2,
1215: p_version_number NUMBER,
1216: p_assessment_type VARCHAR2)IS
1217: SELECT 'X'
1218: FROM igs_as_appr_grd_sch
1219: WHERE unit_cd = p_unit_cd AND
1220: version_number = p_version_number AND
1221: assessment_type = p_assessment_type AND
1222: closed_ind = 'N';