APPS.IGS_GR_PRC_GAC dependencies on IGS_GR_GRADUAND

Line 81: IGS_GR_GRADUAND gr

77: v_row_num NUMBER;
78: CURSOR c_susa IS
79: SELECT COUNT(*)
80: FROM IGS_AS_SU_SETATMPT susa,
81: IGS_GR_GRADUAND gr
82: WHERE gr.person_id = p_person_id AND
83: gr.create_dt = p_create_dt AND
84: gr.grd_cal_type = p_grd_cal_type AND
85: gr.grd_ci_sequence_number = p_grd_ci_sequence_number AND

Line 99: FROM IGS_GR_GRADUAND gr,

95: awc.award_course_cd,
96: awc.award_crs_version_number,
97: awc.award_cd,
98: lr.dflt_ind
99: FROM IGS_GR_GRADUAND gr,
100: IGS_GR_AWD_CEREMONY awc,
101: IGS_EN_STDNT_PS_ATT sca,
102: IGS_GR_CRMN gc,
103: IGS_GR_VENUE ve,

Line 161: IGS_GR_GRADUAND gr

157: NOT EXISTS
158: (SELECT susa.unit_set_cd,
159: susa.us_version_number
160: FROM IGS_AS_SU_SETATMPT susa,
161: IGS_GR_GRADUAND gr
162: WHERE gr.person_id = p_person_id AND
163: gr.create_dt = p_create_dt AND
164: gr.grd_cal_type = p_grd_cal_type AND
165: gr.grd_ci_sequence_number = p_grd_ci_sequence_number AND

Line 197: IGS_GR_GRADUAND gr

193: MINUS
194: SELECT susa.unit_set_cd,
195: susa.us_version_number
196: FROM IGS_AS_SU_SETATMPT susa,
197: IGS_GR_GRADUAND gr
198: WHERE gr.person_id = p_person_id AND
199: gr.create_dt = p_create_dt AND
200: gr.grd_cal_type = p_grd_cal_type AND
201: gr.grd_ci_sequence_number = p_grd_ci_sequence_number AND