APPS.IGS_EN_GEN_009 dependencies on IGS_EN_UNIT_SET_CAT

Line 2614: igs_en_unit_set_cat usc

2610: CURSOR c_last_unit_set IS
2611: SELECT susa.unit_set_cd
2612: FROM igs_as_su_setatmpt susa ,
2613: igs_en_unit_set us ,
2614: igs_en_unit_set_cat usc
2615: WHERE susa.person_id = p_person_id AND
2616: susa.course_cd = p_program_cd AND
2617: susa.rqrmnts_complete_dt IS NULL AND
2618: susa.student_confirmed_ind = 'Y' AND

Line 3048: igs_en_unit_set_cat usc

3044: CURSOR c_last_unit_set IS
3045: SELECT susa.unit_set_cd
3046: FROM igs_as_su_setatmpt susa ,
3047: igs_en_unit_set us ,
3048: igs_en_unit_set_cat usc
3049: WHERE susa.person_id = p_person_id AND
3050: susa.course_cd = p_src_program_cd AND
3051: susa.rqrmnts_complete_dt IS NULL AND
3052: susa.student_confirmed_ind = 'Y' AND