eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_010 dependencies on IGS_PS_OFR_OPT_UNIT_SET_V

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 581: FROM igs_ps_ofr_opt_unit_set_v coou , igs_en_unit_set_cat usc

577: -- Modified the cursor to select always the Unit Set with mapping sequence number of '1'
578: -- not the first unit set in mapping by ayedubat as part of the bug fix:2348709
579: CURSOR c_first_us IS
580: SELECT coou.unit_set_cd, coou.us_version_number
581: FROM igs_ps_ofr_opt_unit_set_v coou , igs_en_unit_set_cat usc
582: WHERE coou.course_cd = p_course_cd AND
583: coou.crv_version_number = v_acaiv_rec.crv_version_number AND
584: coou.cal_type = v_acaiv_rec.acad_cal_type AND
585: coou.location_cd = v_acaiv_rec.location_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