APPS.IGS_EN_GEN_009 dependencies on IGS_PS_US_PRENR_CFG

Line 711: igs_ps_us_prenr_cfg upc

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;
715:

Line 2635: FROM igs_ps_us_prenr_cfg

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: )
2638: AND person_id = cp_person_id
2639: AND course_cd = cp_course_cd;

Line 2696: igs_ps_us_prenr_cfg upc

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;
2700:

Line 3069: FROM igs_ps_us_prenr_cfg

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: )
3072: AND person_id = cp_person_id
3073: AND course_cd = cp_course_cd;

Line 3131: igs_ps_us_prenr_cfg upc

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;
3135: