APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_GR_GRADUAND

Line 48: IGS_GR_GRADUAND gr,

44: gr.conferral_dt,
45: gst.s_graduand_status,
46: aw.award_title
47: FROM IGS_EN_STDNT_PS_ATT sca,
48: IGS_GR_GRADUAND gr,
49: IGS_GR_STAT gst,
50: IGS_CA_INST ci,
51: IGS_PS_AWD aw
52: WHERE sca.person_id = p_person_id AND

Line 101: NOT EXISTS (select '1' from IGS_GR_GRADUAND gr

97: p_enrolled_units_ind,
98: p_exclude_research_units_ind,
99: p_exclude_unit_category,
100: p_include_related_crs_ind))) AND
101: NOT EXISTS (select '1' from IGS_GR_GRADUAND gr
102: where gr.person_id = sca.person_id
103: and gr.course_cd = sca.course_cd)
104: ORDER BY 3;
105: BEGIN