APPS.IGS_AS_FINALIZE_GRADE dependencies on IGS_AS_SU_STMPTOUT_ALL

Line 37: v_best_prev_ci_end_dt igs_as_su_stmptout_all.ci_end_dt%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,
41: rp_org.use_most_recent_unit_attempt,

Line 124: FROM igs_as_su_stmptout_all suao,

120: suao.mark_capped_flag,
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'

Line 134: FROM igs_as_su_stmptout_all suao1

130: AND suao.version_number = gsg.version_number
131: AND suao.grade = gsg.grade
132: AND NVL(gsg.closed_ind,'N') = 'N'
133: AND suao.outcome_dt = (SELECT MAX (suao1.outcome_dt)
134: FROM igs_as_su_stmptout_all suao1
135: WHERE suao1.person_id = suao.person_id
136: AND suao1.course_cd = suao.course_cd
137: AND suao1.uoo_id = suao.uoo_id
138: AND suao1.grading_period_cd = suao.grading_period_cd);

Line 189: FROM igs_as_su_stmptout_all suao,

185: suao.mark_capped_flag,
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

Line 201: FROM igs_as_su_stmptout_all suao1

197: AND suao.version_number = gsg.version_number
198: AND suao.grade = gsg.grade
199: AND NVL(gsg.closed_ind,'N') = 'N'
200: AND suao.outcome_dt = (SELECT MAX (suao1.outcome_dt)
201: FROM igs_as_su_stmptout_all suao1
202: WHERE suao1.person_id = suao.person_id
203: AND suao1.course_cd = suao.course_cd
204: AND suao1.uoo_id = suao.uoo_id
205: AND suao1.grading_period_cd = suao.grading_period_cd);

Line 208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,

204: AND suao1.uoo_id = suao.uoo_id
205: AND suao1.grading_period_cd = suao.grading_period_cd);
206:
207: CURSOR c_prev_suao (
208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE

Line 209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,

205: AND suao1.grading_period_cd = suao.grading_period_cd);
206:
207: CURSOR c_prev_suao (
208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE
213: ) IS

Line 210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,

206:
207: CURSOR c_prev_suao (
208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE
213: ) IS
214: SELECT sua.person_id,

Line 211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,

207: CURSOR c_prev_suao (
208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE
213: ) IS
214: SELECT sua.person_id,
215: sua.course_cd,

Line 212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE

208: cp_person_id igs_as_su_stmptout_all.person_id%TYPE,
209: cp_unit_cd igs_as_su_stmptout_all.unit_cd%TYPE,
210: cp_course_cd igs_as_su_stmptout_all.course_cd%TYPE,
211: cp_cal_type igs_as_su_stmptout_all.cal_type%TYPE,
212: cp_ci_sequence_number igs_as_su_stmptout_all.ci_sequence_number%TYPE
213: ) IS
214: SELECT sua.person_id,
215: sua.course_cd,
216: sua.unit_cd,

Line 263: igs_as_su_stmptout_all suao,

259: suao.release_date,
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