APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_PS_OFR_OPT_ALL

Line 972: igs_ps_ofr_opt_all coo,

968: yop.us_version_number,
969: yop.sequence_number
970: FROM igs_en_susa_year_v yop,
971: igs_en_stdnt_ps_att_all spa,
972: igs_ps_ofr_opt_all coo,
973: igs_he_poous_all hpoous
974: WHERE yop.person_id = cp_person_id
975: AND yop.course_cd = cp_course_cd
976: AND yop.completion_dt IS NULL