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.

[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_EN_UNIT_SET_CAT

Line 2756: FROM igs_as_su_setatmpt susa , igs_en_unit_set us , igs_en_unit_set_cat usc

2752:
2753: -- get the currently active unit set for the person course attempt
2754: CURSOR c_active_us IS
2755: SELECT susa.selection_dt
2756: FROM igs_as_su_setatmpt susa , igs_en_unit_set us , igs_en_unit_set_cat usc
2757: WHERE susa.person_id = p_person_id AND
2758: susa.course_cd = p_course_cd AND
2759: susa.selection_dt IS NOT NULL AND
2760: susa.end_dt IS NULL AND

Line 2770: FROM igs_as_su_setatmpt susa , igs_en_unit_set us , igs_en_unit_set_cat usc

2766:
2767: -- find the last active unit set for the person program
2768: CURSOR c_last_us IS
2769: SELECT susa.selection_dt
2770: FROM igs_as_su_setatmpt susa , igs_en_unit_set us , igs_en_unit_set_cat usc
2771: WHERE susa.person_id = p_person_id AND
2772: susa.course_cd = p_course_cd AND
2773: susa.rqrmnts_complete_dt IS NOT NULL AND
2774: susa.unit_set_cd = us.unit_set_cd AND