APPS.IGS_PS_GEN_008 dependencies on IGS_PS_USEC_X_GRPMEM

Line 2735: AND uoo.uoo_id NOT IN (SELECT uoo_id FROM igs_ps_usec_x_grpmem);

2731: AND uoo.unit_cd = uv.unit_cd
2732: AND uoo.version_number = uv.version_number
2733: AND uv.unit_status = us.unit_status
2734: AND us.s_unit_status <> l_c_inactive
2735: AND uoo.uoo_id NOT IN (SELECT uoo_id FROM igs_ps_usec_x_grpmem);
2736:
2737:
2738: --Cursor to get list the subordiante unit sections have been rolled over
2739: CURSOR c_get_sub_us_list1 IS

Line 2789: AND uoo.uoo_id NOT IN (SELECT uoo_id FROM igs_ps_usec_x_grpmem)

2785: AND uoo.unit_cd = uv.unit_cd
2786: AND uoo.version_number = uv.version_number
2787: AND uv.unit_status = us.unit_status
2788: AND us.s_unit_status <> l_c_inactive
2789: AND uoo.uoo_id NOT IN (SELECT uoo_id FROM igs_ps_usec_x_grpmem)
2790: AND uoo.unit_section_status <> l_c_notoffered;
2791:
2792: CURSOR c_new_sup_us1 (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2793: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

Line 2803: AND uoo_id NOT IN (SELECT uoo_id FROM igs_ps_usec_x_grpmem)

2799: AND version_number = cp_version_number
2800: AND location_cd = cp_location_cd
2801: AND unit_class = cp_unit_class
2802: AND relation_type IN (l_c_superior,l_c_none)
2803: AND uoo_id NOT IN (SELECT uoo_id FROM igs_ps_usec_x_grpmem)
2804: AND unit_section_Status <> l_c_notoffered;
2805:
2806: l_c_get_old_uoo_det c_get_old_uoo_det%ROWTYPE;
2807: l_c_new_sup_uoo_id c_new_sup_uoo_id%ROWTYPE;