APPS.IGS_GR_PRC_GAC dependencies on IGS_AS_SU_SETATMPT

Line 80: FROM IGS_AS_SU_SETATMPT susa,

76: v_cntr NUMBER;
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

Line 160: FROM IGS_AS_SU_SETATMPT susa,

156: acusg.closed_ind = 'N' AND
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

Line 196: FROM IGS_AS_SU_SETATMPT susa,

192: acus.us_group_number = acusg.us_group_number
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