APPS.IGS_AS_ADI_UPLD_UG_PKG dependencies on IGS_PS_UNIT_OFR_OPT

Line 590: FROM igs_ps_unit_ofr_opt

586: --
587: --
588: CURSOR cur_uoo_id IS
589: SELECT uoo_id
590: FROM igs_ps_unit_ofr_opt
591: WHERE unit_cd = p_unit_cd
592: AND cal_type = p_cal_type
593: AND ci_sequence_number = p_ci_sequence_number
594: AND location_cd = p_location_cd

Line 681: --igs_ps_unit_ofr_opt uoo,

677: SELECT sua.unit_attempt_status,
678: NVL (ugs.grading_schema_code, ungs.GRADING_SCHEMA_CODE),
679: NVL (ugs.grd_schm_version_number, ungs.GRD_SCHM_VERSION_NUMBER)
680: FROM igs_en_su_attempt sua,
681: --igs_ps_unit_ofr_opt uoo,
682: IGS_PS_UNIT_GRD_SCHM ungs,
683: igs_ps_usec_grd_schm ugs
684: WHERE sua.person_id = p_person_id
685: AND sua.course_cd = p_course_cd

Line 741: CURSOR c_gsh (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

737: AND p_mark BETWEEN lower_mark_range AND upper_mark_range + 0.999;
738: --
739: -- Get Grading Submission History
740: --
741: CURSOR c_gsh (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
742: SELECT gsh.submission_status
743: FROM igs_as_gaa_sub_hist gsh
744: WHERE gsh.uoo_id = cp_uoo_id
745: AND gsh.grading_period_cd = p_grading_period_cd;