APPS.IGS_AS_NOTIFY_PKG dependencies on IGS_AS_GAA_SUB_HIST

Line 323: FROM igs_as_gaa_sub_hist gash

319: AND utr.lead_instructor_flag (+) = 'Y' ;
320:
321: CURSOR c_attend_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
322: SELECT 'X'
323: FROM igs_as_gaa_sub_hist gash
324: WHERE gash.uoo_id = cp_uoo_id
325: AND gash.submission_type = 'ATTENDANCE'
326: AND gash.submission_status = 'COMPLETE'
327: AND gash.submitted_date = (

Line 329: FROM igs_as_gaa_sub_hist gash2

325: AND gash.submission_type = 'ATTENDANCE'
326: AND gash.submission_status = 'COMPLETE'
327: AND gash.submitted_date = (
328: SELECT MAX(gash2.submitted_date)
329: FROM igs_as_gaa_sub_hist gash2
330: WHERE gash2.uoo_id = cp_uoo_id
331: AND gash2.submission_type = 'ATTENDANCE');
332:
333: CURSOR c_midterm_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE)IS

Line 335: FROM igs_as_gaa_sub_hist gash

331: AND gash2.submission_type = 'ATTENDANCE');
332:
333: CURSOR c_midterm_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE)IS
334: SELECT 'X'
335: FROM igs_as_gaa_sub_hist gash
336: WHERE gash.uoo_id = cp_uoo_id
337: AND gash.submission_type = 'GRADE'
338: AND gash.grading_period_cd = 'MIDTERM'
339: AND gash.submission_status = 'COMPLETE'

Line 342: FROM igs_as_gaa_sub_hist gash2

338: AND gash.grading_period_cd = 'MIDTERM'
339: AND gash.submission_status = 'COMPLETE'
340: AND gash.submitted_date = (
341: SELECT MAX(gash2.submitted_date)
342: FROM igs_as_gaa_sub_hist gash2
343: WHERE gash2.uoo_id = cp_uoo_id
344: AND gash2.submission_type = 'GRADE'
345: AND gash2.grading_period_cd = 'MIDTERM');
346:

Line 349: FROM igs_as_gaa_sub_hist gash

345: AND gash2.grading_period_cd = 'MIDTERM');
346:
347: CURSOR c_earlyfinal_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
348: SELECT 'X'
349: FROM igs_as_gaa_sub_hist gash
350: WHERE gash.uoo_id = cp_uoo_id
351: AND gash.submission_type = 'GRADE'
352: AND gash.grading_period_cd = 'EARLY_FINAL'
353: AND gash.submission_status = 'COMPLETE'

Line 356: FROM igs_as_gaa_sub_hist gash2

352: AND gash.grading_period_cd = 'EARLY_FINAL'
353: AND gash.submission_status = 'COMPLETE'
354: AND gash.submitted_date = (
355: SELECT MAX(gash2.submitted_date)
356: FROM igs_as_gaa_sub_hist gash2
357: WHERE gash2.uoo_id = cp_uoo_id
358: AND gash2.submission_type = 'GRADE'
359: AND gash2.grading_period_cd = 'EARLY_FINAL');
360:

Line 363: FROM igs_as_gaa_sub_hist gash

359: AND gash2.grading_period_cd = 'EARLY_FINAL');
360:
361: CURSOR c_final_gash (cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
362: SELECT 'X'
363: FROM igs_as_gaa_sub_hist gash
364: WHERE gash.uoo_id = cp_uoo_id
365: AND gash.submission_type = 'GRADE'
366: AND gash.grading_period_cd = 'FINAL'
367: AND gash.submission_status = 'COMPLETE'

Line 370: FROM igs_as_gaa_sub_hist gash2

366: AND gash.grading_period_cd = 'FINAL'
367: AND gash.submission_status = 'COMPLETE'
368: AND gash.submitted_date = (
369: SELECT MAX(gash2.submitted_date)
370: FROM igs_as_gaa_sub_hist gash2
371: WHERE gash2.uoo_id = cp_uoo_id
372: AND gash2.submission_type = 'GRADE'
373: AND gash2.grading_period_cd = 'FINAL');
374: