APPS.IGS_PS_GEN_003 dependencies on IGS_EN_SU_ATTEMPT

Line 919: Purpose : To check if enrollment exists for a unit section, i.e to check if a record exists in IGS_EN_SU_ATTEMPT

915:
916: Created By : sarakshi
917: Date Created By: 21-oct-2003
918:
919: Purpose : To check if enrollment exists for a unit section, i.e to check if a record exists in IGS_EN_SU_ATTEMPT
920: for the input unit section
921:
922: Known limitations,enhancements,remarks:
923: Change History

Line 927: CURSOR c_enroll (cp_n_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

923: Change History
924: Who When What
925:
926: ********************************************************************************************** */
927: CURSOR c_enroll (cp_n_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
928: SELECT 'X'
929: FROM igs_en_su_attempt
930: WHERE uoo_id=cp_n_uoo_id
931: AND ROWNUM=1;

Line 929: FROM igs_en_su_attempt

925:
926: ********************************************************************************************** */
927: CURSOR c_enroll (cp_n_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
928: SELECT 'X'
929: FROM igs_en_su_attempt
930: WHERE uoo_id=cp_n_uoo_id
931: AND ROWNUM=1;
932: l_c_var VARCHAR2(1) ;
933: