APPS.IGS_EN_OFR_WLST_OPT dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 5: EN_SUA_REC_TYPE IGS_EN_SU_ATTEMPT_ALL%ROWTYPE;

1: PACKAGE BODY igs_en_ofr_wlst_opt as
2: /* $Header: IGSEN75B.pls 120.2 2006/01/16 22:42:18 smaddali ship $ */
3:
4:
5: EN_SUA_REC_TYPE IGS_EN_SU_ATTEMPT_ALL%ROWTYPE;
6:
7: FUNCTION ofr_enrollment_or_waitlist ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
8: p_session_id IN igs_en_su_attempt.session_id%TYPE,
9: p_waitlist_ind IN VARCHAR2,

Line 105: FROM igs_en_su_attempt_all su

101: l_c_igs_ps_rsv_ext c_igs_ps_rsv_ext%ROWTYPE ;
102:
103: CURSOR c_igs_en_su_attempt(cp_rowid VARCHAR2) IS
104: SELECT su.*
105: FROM igs_en_su_attempt_all su
106: WHERE su.rowid = cp_rowid ;
107:
108: l_c_igs_en_su_attempt c_igs_en_su_attempt%ROWTYPE ;
109: l_override_achievable_cp igs_en_su_attempt.override_achievable_cp%TYPE;