APPS.IGS_EN_GEN_009 dependencies on IGS_EN_UNIT_SET_MAP

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