APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 637: CURSOR cur_std_attempt(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

633: AND uoo.uoo_id=p_n_uoo_id;
634:
635: cur_usec_rec cur_usec%ROWTYPE;
636:
637: CURSOR cur_std_attempt(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
638: SELECT *
639: FROM igs_en_su_attempt
640: WHERE uoo_id=cp_uoo_id
641: AND unit_attempt_status='WAITLISTED';

Line 639: FROM igs_en_su_attempt

635: cur_usec_rec cur_usec%ROWTYPE;
636:
637: CURSOR cur_std_attempt(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
638: SELECT *
639: FROM igs_en_su_attempt
640: WHERE uoo_id=cp_uoo_id
641: AND unit_attempt_status='WAITLISTED';
642:
643: CURSOR c_x_grpmem(cp_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

Line 1259: CURSOR cur_std_attempt(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

1255: WHERE uoo_id=cp_uoo_id;
1256:
1257: c_uso_cm_rec c_uso_cm%ROWTYPE;
1258:
1259: CURSOR cur_std_attempt(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1260: SELECT *
1261: FROM igs_en_su_attempt
1262: WHERE uoo_id=cp_uoo_id
1263: AND unit_attempt_status='WAITLISTED';

Line 1261: FROM igs_en_su_attempt

1257: c_uso_cm_rec c_uso_cm%ROWTYPE;
1258:
1259: CURSOR cur_std_attempt(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
1260: SELECT *
1261: FROM igs_en_su_attempt
1262: WHERE uoo_id=cp_uoo_id
1263: AND unit_attempt_status='WAITLISTED';
1264:
1265: CURSOR cur_waitlist(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS