APPS.IGS_PS_CAL_RSR_VAL dependencies on IGS_PS_RSV_USEC_PRF

Line 135: SELECT a.rowid FROM igs_ps_rsv_usec_prf a

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;
139: l_cur_preference_row cur_preference%ROWTYPE;

Line 246: igs_ps_rsv_usec_prf_pkg.delete_row(

242: -- Deleting all the Priority and Preference
243:
244: FOR pri IN cur_priority(r_cur_uoo.uoo_id) LOOP
245: FOR pref IN cur_preference(pri.rsv_usec_pri_id) LOOP
246: igs_ps_rsv_usec_prf_pkg.delete_row(
247: x_rowid=>pref.rowid
248: );
249: END LOOP;
250: igs_ps_rsv_usec_pri_pkg.delete_row(