APPS.IGS_EN_GEN_010 dependencies on IGS_EN_UNIT_SET_STAT

Line 567: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca

563: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
564: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
565: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
566: SELECT coous.us_version_number
567: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca
568: WHERE sca.person_id = cp_person_id AND
569: sca.course_cd = cp_course_cd AND
570: sca.coo_id = coous.coo_id AND
571: coous.unit_set_cd = cp_unit_set_cd AND

Line 4288: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca

4284: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
4285: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
4286: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
4287: SELECT coous.us_version_number
4288: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca
4289: WHERE sca.person_id = cp_person_id AND
4290: sca.course_cd = cp_course_cd AND
4291: sca.coo_id = coous.coo_id AND
4292: coous.unit_set_cd = cp_unit_set_cd AND

Line 7956: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca

7952: CURSOR c_us_version_number(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
7953: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
7954: cp_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE) IS
7955: SELECT coous.us_version_number
7956: FROM igs_en_unit_set_stat uss, igs_ps_ofr_opt_unit_set_v coous, igs_en_stdnt_ps_att sca
7957: WHERE sca.person_id = cp_person_id AND
7958: sca.course_cd = cp_course_cd AND
7959: sca.coo_id = coous.coo_id AND
7960: coous.unit_set_cd = cp_unit_set_cd AND