APPS.IGS_GR_GEN_001 dependencies on IGS_GR_HONOURS_LEVEL

Line 623: v_govt_honours_level igs_gr_honours_level.govt_honours_level%TYPE;

619: END IF;
620: --
621: DECLARE
622: --
623: v_govt_honours_level igs_gr_honours_level.govt_honours_level%TYPE;
624: --
625: CURSOR c_gr_gst_aw_hl IS
626: SELECT hl.govt_honours_level
627: FROM igs_gr_graduand_all gr,

Line 630: igs_gr_honours_level hl

626: SELECT hl.govt_honours_level
627: FROM igs_gr_graduand_all gr,
628: igs_gr_stat gst,
629: igs_ps_awd aw,
630: igs_gr_honours_level hl
631: WHERE gr.person_id = p_person_id
632: AND gr.course_cd = p_course_cd
633: AND gr.award_course_cd = gr.course_cd
634: AND gst.graduand_status = gr.graduand_status