APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_RSV_USEC_PRI

Line 2019: FROM igs_ps_rsv_usec_pri usprv,igs_ps_rsv_usec_prf uspfv

2015: l_n_count_msg NUMBER(6);
2016:
2017: CURSOR c_rsv_perc_sum( cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
2018: SELECT nvl(SUM(percentage_reserved),0) percentage_reserved
2019: FROM igs_ps_rsv_usec_pri usprv,igs_ps_rsv_usec_prf uspfv
2020: WHERE usprv.rsv_usec_pri_id = uspfv.rsv_usec_pri_id
2021: AND usprv.uoo_id =cp_uoo_id;
2022:
2023: c_rsv_perc_sum_rec c_rsv_perc_sum%ROWTYPE;

Line 2027: FROM igs_ps_rsv_usec_pri

2023: c_rsv_perc_sum_rec c_rsv_perc_sum%ROWTYPE;
2024:
2025: CURSOR c_usec_rsvpric_ser(cp_uoo_id NUMBER) IS
2026: SELECT priority_order
2027: FROM igs_ps_rsv_usec_pri
2028: WHERE uoo_id=cp_uoo_id
2029: ORDER BY priority_order;
2030:
2031: CURSOR cur_priority_id(cp_uoo_id NUMBER) IS

Line 2033: FROM igs_ps_rsv_usec_pri

2029: ORDER BY priority_order;
2030:
2031: CURSOR cur_priority_id(cp_uoo_id NUMBER) IS
2032: SELECT rsv_usec_pri_id,priority_value
2033: FROM igs_ps_rsv_usec_pri
2034: WHERE uoo_id=cp_uoo_id;
2035:
2036: CURSOR c_usec_rsvprfc_ser(cp_rsv_usec_pri_id NUMBER) IS
2037: SELECT preference_order