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_009 dependencies on IGS_EN_UNIT_SET

Line 710: FROM igs_en_unit_set_map usm,

706: v_index BINARY_INTEGER;
707:
708: CURSOR c_acad_us (cp_admin_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE) IS
709: SELECT usm.stream_unit_set_Cd
710: FROM igs_en_unit_set_map usm,
711: igs_ps_us_prenr_cfg upc
712: WHERE upc.unit_set_cd = cp_admin_unit_set_cd
713: AND usm.mapping_set_cd = upc.mapping_set_cd
714: AND usm.sequence_no = upc.sequence_no;

Line 2613: igs_en_unit_set us ,

2609:
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

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 2633: FROM igs_en_unit_set_map

2629: FROM igs_as_su_setatmpt
2630: WHERE (
2631: (unit_set_cd = cp_unit_set_cd) OR
2632: (unit_set_cd IN (SELECT stream_unit_set_cd
2633: FROM igs_en_unit_set_map
2634: WHERE (mapping_set_cd,sequence_no) IN (SELECT mapping_set_cd,sequence_no
2635: FROM igs_ps_us_prenr_cfg
2636: WHERE unit_set_cd = cp_unit_set_cd)))
2637: )

Line 2695: FROM igs_en_unit_set_map usm,

2691: l_aci_rec c_aci%ROWTYPE;
2692:
2693: CURSOR c_acad_us (cp_admin_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
2694: SELECT usm.stream_unit_set_Cd
2695: FROM igs_en_unit_set_map usm,
2696: igs_ps_us_prenr_cfg upc
2697: WHERE upc.unit_set_cd = cp_admin_unit_set_cd
2698: AND usm.mapping_set_cd = upc.mapping_set_cd
2699: AND usm.sequence_no = upc.sequence_no;

Line 3047: igs_en_unit_set us ,

3043:
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

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

Line 3067: FROM igs_en_unit_set_map

3063: FROM igs_as_su_setatmpt
3064: WHERE (
3065: (unit_set_cd = cp_unit_set_cd) OR
3066: (unit_set_cd IN (SELECT stream_unit_set_cd
3067: FROM igs_en_unit_set_map
3068: WHERE (mapping_set_cd,sequence_no) IN (SELECT mapping_set_cd,sequence_no
3069: FROM igs_ps_us_prenr_cfg
3070: WHERE unit_set_cd = cp_unit_set_cd)))
3071: )

Line 3130: FROM igs_en_unit_set_map usm,

3126: l_aci_rec c_aci%ROWTYPE;
3127:
3128: CURSOR c_acad_us (cp_admin_unit_Set_cd igs_as_su_setatmpt.unit_set_cd%TYPE) IS
3129: SELECT usm.stream_unit_set_Cd
3130: FROM igs_en_unit_set_map usm,
3131: igs_ps_us_prenr_cfg upc
3132: WHERE upc.unit_set_cd = cp_admin_unit_set_cd
3133: AND usm.mapping_set_cd = upc.mapping_set_cd
3134: AND usm.sequence_no = upc.sequence_no;