APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_EN_SPA_AWD_AIM

Line 247: igs_en_spa_awd_aim enawd,

243: enawd.conferral_date
244: FROM igs_en_stdnt_ps_att_all sca,
245: igs_he_st_spa_all hspa,
246: igs_he_st_prog_all hprog,
247: igs_en_spa_awd_aim enawd,
248: hz_parties pe
249: WHERE sca.person_id = hspa.person_id (+)
250: AND sca.course_cd = hspa.course_cd (+)
251: AND sca.course_cd = hprog.course_cd (+)

Line 292: igs_en_spa_awd_aim enawd,

288: FROM igs_as_su_setatmpt susa,
289: igs_he_en_susa husa,
290: igs_en_unit_set us,
291: igs_en_unit_set_cat susc,
292: igs_en_spa_awd_aim enawd,
293: igs_en_stdnt_ps_att_all sca
294: WHERE susa.person_id = sca.person_id
295: AND susa.course_cd = sca.course_cd
296: AND sca.person_id = enawd.person_id(+)