APPS.IGS_PS_CAL_RSR_VAL dependencies on IGS_PS_RSV_USEC_PRI_V

Line 131: SELECT * FROM igs_ps_rsv_usec_pri_v

127:
128: my_continue EXCEPTION;
129:
130: CURSOR cur_priority (l_uoo_id NUMBER) IS
131: SELECT * FROM igs_ps_rsv_usec_pri_v
132: WHERE uoo_id = l_uoo_id;
133:
134: CURSOR cur_preference(l_rsv_usec_pri_id igs_ps_rsv_usec_pri_v.rsv_usec_pri_id%TYPE) IS
135: SELECT a.rowid FROM igs_ps_rsv_usec_prf a

Line 134: CURSOR cur_preference(l_rsv_usec_pri_id igs_ps_rsv_usec_pri_v.rsv_usec_pri_id%TYPE) IS

130: CURSOR cur_priority (l_uoo_id NUMBER) IS
131: SELECT * FROM igs_ps_rsv_usec_pri_v
132: WHERE uoo_id = l_uoo_id;
133:
134: CURSOR cur_preference(l_rsv_usec_pri_id igs_ps_rsv_usec_pri_v.rsv_usec_pri_id%TYPE) IS
135: SELECT a.rowid FROM igs_ps_rsv_usec_prf a
136: WHERE a.rsv_usec_pri_id = l_rsv_usec_pri_id;
137:
138: l_cur_priority_row cur_priority%ROWTYPE;