APPS.IGS_GR_GEN_001 dependencies on IGS_GR_STAT

Line 235: igs_gr_stat gst

231: CURSOR c_gr IS
232: SELECT gr.person_id,
233: gr.create_dt
234: FROM igs_gr_graduand_all gr,
235: igs_gr_stat gst
236: WHERE gr.grd_cal_type = p_grd_cal_type
237: AND gr.grd_ci_sequence_number = p_grd_ci_sequence_number
238: AND gr.graduand_status = gst.graduand_status
239: AND gst.s_graduand_status = 'POTENTIAL'

Line 628: igs_gr_stat gst,

624: --
625: CURSOR c_gr_gst_aw_hl IS
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