DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 180: l_unit_attempt_status igs_en_su_attempt_all.unit_attempt_status%TYPE;

176: l_cross_list c_cross_list%ROWTYPE;
177: l_class_meet c_class_meet%ROWTYPE;
178: l_usec_partof_group BOOLEAN;
179: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE; --added by nishikant
180: l_unit_attempt_status igs_en_su_attempt_all.unit_attempt_status%TYPE;
181: l_credit_points igs_ps_unit_ver.enrolled_credit_points%type;
182: l_deny_unit_steps BOOLEAN;
183: l_warn_unit_steps BOOLEAN;
184: l_message_icon VARCHAR2(1);

Line 2524: igs_en_su_attempt_all ua,

2520: uoo.unit_class,
2521: NVL (uocur.start_date, NVL (uoo.unit_section_start_date, lt.start_dt)) start_date,
2522: NVL (uocur.end_date, NVL (uoo.unit_section_end_date, lt.end_dt)) end_date
2523: FROM igs_ps_usec_occurs uocur,
2524: igs_en_su_attempt_all ua,
2525: igs_ca_inst lt,
2526: igs_ps_unit_ofr_opt_all uoo
2527: WHERE uocur.uoo_id = ua.uoo_id
2528: AND uoo.uoo_id = ua.uoo_id