APPS.IGS_PS_USEC_LIM_WLST_PKG dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 369: CURSOR cur_unit_limit(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

365: sarakshi 05-May-2005 Bug#4349740, added the after dml update/insert logic
366: (reverse chronological order - newest change first)
367: ***************************************************************/
368:
369: CURSOR cur_unit_limit(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
370: SELECT enrollment_maximum,enrollment_expected,override_enrollment_max
371: FROM igs_ps_unit_ver_all uv,
372: igs_ps_unit_ofr_opt_all uoo
373: WHERE uv.unit_cd=uoo.unit_cd

Line 372: igs_ps_unit_ofr_opt_all uoo

368:
369: CURSOR cur_unit_limit(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
370: SELECT enrollment_maximum,enrollment_expected,override_enrollment_max
371: FROM igs_ps_unit_ver_all uv,
372: igs_ps_unit_ofr_opt_all uoo
373: WHERE uv.unit_cd=uoo.unit_cd
374: AND uv.version_number=uoo.version_number
375: AND uoo.uoo_id=cp_uoo_id;
376: l_c_unit cur_unit_limit%ROWTYPE;