APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 71: FROM igs_en_su_attempt_all

67:
68: -- Cursor to check whether any unit attempt exists for the unit section with unit attempt status other than 'DISCONTIN' and 'DROPPED'.
69: CURSOR c_discontin(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
70: SELECT unit_attempt_status
71: FROM igs_en_su_attempt_all
72: WHERE uoo_id= cp_n_uoo_id
73: AND unit_attempt_status NOT IN ('DISCONTIN', 'DROPPED')
74: AND ROWNUM <2 ;
75:

Line 76: l_c_unit_attempt_status igs_en_su_attempt_all.unit_attempt_status%TYPE;

72: WHERE uoo_id= cp_n_uoo_id
73: AND unit_attempt_status NOT IN ('DISCONTIN', 'DROPPED')
74: AND ROWNUM <2 ;
75:
76: l_c_unit_attempt_status igs_en_su_attempt_all.unit_attempt_status%TYPE;
77:
78: -- Cursor to check whether any unit attempt exists for the unit section.
79: CURSOR c_exist (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
80: SELECT 1

Line 81: FROM igs_en_su_attempt_all

77:
78: -- Cursor to check whether any unit attempt exists for the unit section.
79: CURSOR c_exist (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
80: SELECT 1
81: FROM igs_en_su_attempt_all
82: WHERE uoo_id = cp_n_uoo_id
83: AND ROWNUM < 2 ;
84:
85: l_n_exist NUMBER;

Line 91: FROM igs_en_su_attempt_all

87: -- Cursor to check whether unit attempt exists for the unit section in unit attempt statuses
88: -- other than 'DISCONTIN','DROPPED','COMPLETED','DUPLICATE'
89: CURSOR c_enrollment_status(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
90: SELECT DISTINCT unit_attempt_status
91: FROM igs_en_su_attempt_all
92: WHERE uoo_id = cp_n_uoo_id
93: AND unit_attempt_status NOT IN ('DISCONTIN','DROPPED','COMPLETED','DUPLICATE');
94:
95: