APPS.IGS_EN_HESA_PKG dependencies on IGS_HE_CODE_VALUES

Line 986: igs_he_code_values hcv

982: -- smaddali added condition to get only open code values for bug 2730388
983: CURSOR cur_hqual_grade IS
984: SELECT 'x'
985: FROM igs_as_grd_sch_grade gsg,
986: igs_he_code_values hcv
987: WHERE gsg.grading_schema_cd = hcv.value AND
988: hcv.code_type = 'HESA_HIGH_QUAL_ON_ENT' AND
989: gsg.grade = p_highest_qual_on_entry AND
990: NVL(hcv.closed_ind,'N') = 'N' ;