APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_AS_GRD_SCHEMA

Line 1225: FROM igs_as_grd_schema gs,

1221: -- cursor to derive the grade (honors level)
1222: CURSOR c_honors_level (cp_award_cd igs_ps_awd.award_cd%TYPE,
1223: cp_sum NUMBER) IS
1224: SELECT gsg.grade, gs.grading_schema_cd, gs.version_number
1225: FROM igs_as_grd_schema gs,
1226: igs_as_grd_sch_grade gsg,
1227: igs_ps_awd pa
1228: WHERE gs.grading_schema_cd = gsg.grading_schema_cd
1229: AND gs.version_number = gsg.version_number

Line 1239: FROM igs_as_grd_schema gs,

1235: AND NVL(gsg.upper_mark_range, 1) >= NVL((cp_sum), NVL(gsg.upper_mark_range, 1));
1236:
1237: CURSOR c_honors_level1 (cp_sum NUMBER) IS
1238: SELECT gsg.grade, gs.grading_schema_cd, gs.version_number
1239: FROM igs_as_grd_schema gs,
1240: igs_as_grd_sch_grade gsg
1241: WHERE gs.grading_schema_cd = gsg.grading_schema_cd
1242: AND gs.version_number = gsg.version_number
1243: AND gs.grading_schema_type = 'HONORS'

Line 1614: FROM igs_as_grd_schema gs, igs_as_grd_sch_grade gsg

1610:
1611: CURSOR Cur_Awd_grd(cp_grd_sch VARCHAR2, cp_grd_ver NUMBER, cp_grade VARCHAR2) IS
1612: SELECT gsg.grade, gs.grading_schema_cd, gs.version_number,
1613: gsg.lower_mark_range, gsg.upper_mark_range
1614: FROM igs_as_grd_schema gs, igs_as_grd_sch_grade gsg
1615: WHERE gs.grading_schema_cd = gsg.grading_schema_cd
1616: AND gs.version_number = gsg.version_number
1617: AND gs.grading_schema_type = 'HONORS'
1618: AND gs.grading_schema_cd = cp_grd_sch