APPS.IGS_EN_HESA_PKG dependencies on IGS_AS_GRD_SCH_GRADE

Line 985: FROM igs_as_grd_sch_grade gsg,

981: -- cursor to check whether the given grade exists against the grading schema defined for HESA code HESA_HIGH_QUAL_ON_ENT.
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

Line 1108: FROM igs_as_grd_sch_grade gsg,

1104: --
1105: -- cursor to check whether the given grade is exists against the grading schema defined in Unit set statistics.
1106: CURSOR cur_grd_sch_grade IS
1107: SELECT 'x'
1108: FROM igs_as_grd_sch_grade gsg,
1109: igs_he_poous_all poous,
1110: igs_en_stdnt_ps_att sca,
1111: igs_as_su_setatmpt susa
1112: WHERE gsg.grading_schema_cd = poous.grading_schema_cd AND