APPS.IGS_AS_FINALIZE_GRADE dependencies on IGS_AS_GRD_SCH_GRADE

Line 36: v_best_prev_rank igs_as_grd_sch_grade.RANK%TYPE;

32: v_translated_version_number igs_as_grd_sch_trn_all.to_version_number%TYPE;
33: v_translated_grade igs_as_grd_sch_trn_all.to_grade%TYPE;
34: v_translated_dt DATE;
35: v_rowid VARCHAR2 (25);
36: v_best_prev_rank igs_as_grd_sch_grade.RANK%TYPE;
37: v_best_prev_ci_end_dt igs_as_su_stmptout_all.ci_end_dt%TYPE;
38:
39: CURSOR c_rp IS
40: SELECT uv.repeatable_ind,

Line 125: igs_as_grd_sch_grade gsg

121: suao.release_date,
122: suao.manual_override_flag,
123: suao.show_on_academic_histry_flag
124: FROM igs_as_su_stmptout_all suao,
125: igs_as_grd_sch_grade gsg
126: WHERE suao.uoo_id = p_uoo_id
127: AND suao.finalised_outcome_ind = 'N'
128: AND suao.grading_period_cd = 'FINAL'
129: AND suao.grading_schema_cd = gsg.grading_schema_cd

Line 190: igs_as_grd_sch_grade gsg

186: suao.release_date,
187: suao.manual_override_flag,
188: suao.show_on_academic_histry_flag
189: FROM igs_as_su_stmptout_all suao,
190: igs_as_grd_sch_grade gsg
191: WHERE suao.person_id = p_person_id
192: AND suao.course_cd = p_course_cd
193: AND suao.uoo_id = p_uoo_id
194: AND suao.finalised_outcome_ind = 'N'

Line 264: igs_as_grd_sch_grade gsg

260: suao.manual_override_flag,
261: suao.show_on_academic_histry_flag
262: FROM igs_en_su_attempt sua,
263: igs_as_su_stmptout_all suao,
264: igs_as_grd_sch_grade gsg
265: WHERE sua.person_id = cp_person_id
266: AND sua.unit_cd = cp_unit_cd
267: AND (sua.course_cd <> cp_course_cd
268: OR sua.cal_type <> cp_cal_type